Hi,
I have a sheet with 8 columns that records the courses that people in the
company go on. The heading a Rec ID, Name, Dept, Team, Course, Cost,
Status, budget.
Each row is unqiue and probably reach 100. (I understand to use match that I
will have to extend my columns to this amount but thats not a problem)

I need to produce a report that will allow me to select a dept and all the
rows that have that show that dept are copied to another area under a
prepared title.

I know you can use advance filter but that means copying and pasting but
this has to be automated so anyone can do it.

This is a panic job.... so many thanks.
Colin