T
tim
I have a work schedule that has a seperate sheet for different types of
scheduled time off Vacation time by weeks, Vacation time by days,
Personal time by days and so on. I would like to add a new sheet that I
could just key in the week ending date and i would get who will be off.
Column A on all sheets have the dates and i would want to bring back
the info in column B from each sheet. The problem is I have only used
VLOOKUP and I would be bring back up to 10 entries from each sheet. Is
something like this actually possible?
scheduled time off Vacation time by weeks, Vacation time by days,
Personal time by days and so on. I would like to add a new sheet that I
could just key in the week ending date and i would get who will be off.
Column A on all sheets have the dates and i would want to bring back
the info in column B from each sheet. The problem is I have only used
VLOOKUP and I would be bring back up to 10 entries from each sheet. Is
something like this actually possible?