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