View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
minx2001 minx2001 is offline
external usenet poster
 
Posts: 1
Default Need to copy rows in Sheet1 to different worksheets


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

--
minx200
-----------------------------------------------------------------------
minx2001's Profile: http://www.excelforum.com/member.php...fo&userid=1516
View this thread: http://www.excelforum.com/showthread.php?threadid=27176