Creating Multiple summary sheets

T

Tony

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top