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

Need to copy rows in Sheet1 to different worksheets
 

Try this
http://www.rondebruin.nl/copy5.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"minx2001" wrote in message ...

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

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

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

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

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

All the help would be highly appreciated.

Thanks in advance.


--
minx2001
------------------------------------------------------------------------
minx2001's Profile: http://www.excelforum.com/member.php...o&userid=15168
View this thread: http://www.excelforum.com/showthread...hreadid=271761