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?


--
tim

THis sounds like a use for a pivot table.

"tim" wrote in message
...

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?


--
tim

Hi Tim

Advanced Filter will do this for you.
Take a look at Debra Dalgleish's site for detailed instructions on how
to extract data to another sheet.
http://www.contextures.com/xladvfilter01.html#ExtractWs

--
Regards

Roger Govier


"tim" wrote in message
...

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?


--
tim