Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
Copy Rows with a cell value 0 from several worksheets to a new sh | Excel Worksheet Functions | |||
Copy Rows with a cell value 0 from several worksheets to a new sh | Excel Worksheet Functions | |||
Copy rows with a cell value 0 from several worksheets to a new sh | Excel Worksheet Functions | |||
Sheet1 object not Worksheets("Sheet1") | Excel Programming |