ChuckRobert
Board Regular
- Joined
- Feb 26, 2009
- Messages
- 64
I am using an advanced filter to find all employees (from a master scheduling workbook) not available to work on a given workday. It is then pasted into a sheet in the weekly schedule.
Is it possible to link this data in some way from that worksheet to another worksheet - daily schedule - to insert in dedicated ranges (referencing Date in specified cell (B3, C3, D3..), and the Reason why they are not available in a specified cell (A60 if Sick, A70 if Training, A80 if Vacation) into specified range for each (ex. B60:B69, B70:B79, B80:B89)
example....
. ....> 05/14/2009
Sick > Joe
. > Sam
Training > Bill
. > John
Vacation > Sally
A VLookup, Match, or IF statement only seems to pulls up the first applicable entry, not all applicable. Suggestions?
Is it possible to link this data in some way from that worksheet to another worksheet - daily schedule - to insert in dedicated ranges (referencing Date in specified cell (B3, C3, D3..), and the Reason why they are not available in a specified cell (A60 if Sick, A70 if Training, A80 if Vacation) into specified range for each (ex. B60:B69, B70:B79, B80:B89)
example....
. ....> 05/14/2009
Sick > Joe
. > Sam
Training > Bill
. > John
Vacation > Sally
A VLookup, Match, or IF statement only seems to pulls up the first applicable entry, not all applicable. Suggestions?
