Need to copy rows in Sheet1 to different worksheets

  • Thread starter Thread starter minx2001
  • Start date Start date
M

minx2001

I am very new to writting macros and really need help.

On my master worksheet I have about 100 rows with information o
different
customers.

I would like to copy information for each customer to a differen
worksheet
unique to that customer.

Therefore, if on the master worksheet I have information on 'John,'
want
that information copied to a worksheet called 'John.'

Then, on the next row, I have information on 'Mary,' that should b
copied
to worksheet called 'Mary,' etc etc.

All the help would be highly appreciated.

Thanks in advance
 

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

Back
Top