Looking for data in 1 worksheet & copying the results into another

[Notazbad]

Hi,

Using Excel 2002.

What I have
I have a workbook (Inventory) with the following data in it.. Username
first name, last name, Department, Division, Computer make, Compute
Model, etc. in addition to various hardware and software inventories o
the computer associated with a particular user.

I have created worksheets for each Department in the 'Inventory
worksheet (e,g Finance)

What I want to do:
e.g .Use a macro, formula etc. to look at column 'F' in the 'inventory
worksheet and copy the entire row of any field that is = to 'Finance'
into the Finance worksheet, HR into the HR worksheet etc.
Once that is done I want to have the resulting information sorted b
Department and Division (Column's F and G)

Thanks in advance

 

[Frank Kabel]

Hi
as a starting point have a look at
http://www.rondebruin.nl/copy5.htm
to copy record with the same information to a new sheet. Apply this
macro for all your different departments

after this I would smply manual sort the resulting sheets