software

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.

quot;timquot; gt; wrote in message
...
gt;
gt; I have a work schedule that has a seperate sheet for different types of
gt; scheduled time off Vacation time by weeks, Vacation time by days,
gt; Personal time by days and so on. I would like to add a new sheet that I
gt; could just key in the week ending date and i would get who will be off.
gt; Column A on all sheets have the dates and i would want to bring back
gt; the info in column B from each sheet. The problem is I have only used
gt; VLOOKUP and I would be bring back up to 10 entries from each sheet. Is
gt; something like this actually possible?
gt;
gt;
gt; --
gt; 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.
www.contextures.com/xladvfilter01.html#ExtractWs

--
Regards

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