It is very poor database management practice to have duplicate data. I
believe everything you want to do could be accomplished using Data Auto
Filter
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"MB" wrote in message
...
Hello,

I have a spreadsheet listing all employees and other data (birth date,
hire
date, department name, etc.). I need a separate sheet for each department
within the same book. For example, all Administration in one sheet, all
Engineering in another, etc.

My data ranges from A2:0141 (headings are in row 1). What is the formula
to
pull each department into it's own sheet? The departments are in column
F.

Thank you.
--
MB