Thread
:
Lookup a value in a list & return multiple corresponding values
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
Posts: n/a
Lookup a value in a list & return multiple corresponding values
have a look at using
datafilterautofilterfilter on the dept
--
Don Guillett
SalesAid Software
"medic" wrote in message
ups.com...
I have a main worksheet that has the following columns, Dept #, First
Name, Last Name, City, Home Phone, Cell/Pager and Position. On
individual worksheets (within this workbook) I would like to display
all the information listed above, but for specific department numbers.
Like department 900 on one worksheet and 901 on another worksheet. Once
these worksheets are created I would like them to be updated when the
main worksheet is updated.
Thank you
Reply With Quote