Creating Multiple summary sheets
 

Hi

I seem to be struggling to find a macro that will work in previous threads.

In sheet 1 is a list of data in columns A:N and the number of rows will
vary. It is a list of sales with each sale record ocuppying one row. The
salesperson's name is in column C and each salesperson will have multiple
entries.

What I am trying to do is create a seperate summary sheet in the workbook
for each salesperson. Therefore sheets 2 to 20 are templates that already
exist with a different salesperson's name entered into cell C3 on each of
them.

I am trying to find a macro that will copy each row from sheet 1 where the
salesperson's name in column C matches the value (salesperson's name) entered
into C3 on one of the sheets 2-20.

Any help would be most appreciated.
Thanks