Hi all

I have a worksheet consisting of staff names in column A and the branch they
work at in Column B. (There are approximately 400 branches, each with
various numbers of staff).

I need to create a separate worksheet for each branch containing their
members of staff.

I have started to do this by using an Advanced Filter and using the relevant
Department name as the Criteria, however, as there are over 400 branches, it
is going to take me hours. I thought it would be easier to use Import
External Data and then I could use a Parameter to show each Branch on
separate pages, however, when I get to the end of the Wizard, it gives me an
Error message.

CAn anybody think of an easier way of doing this? I'm sure there is one....

Thank you.

Louise