Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that copies range to new sheet
I'm trying to get a macro to copy rows in column A to new sheets based
on the value in row A. I really could use some help! Thanks so much. For example original sheet has the values: Column A, Column B Red, 123 Red, 234 Red, 111 Blue, 124 Blue, 453 Yellow, 234 Yellow, 531 Yellow, 123 .... and the macro makes three new sheets: New sheet1: Column A, Column B Red, 123 Red, 234 Red, 111 New sheet2: Column A, Column B Blue, 124 Blue, 453 New sheet3: Column A, Column B Yellow, 234 Yellow, 531 Yellow, 123 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that copies range to new sheet
if you are familiar with VBA, then you could use some sample exce sheets from debra's website www.contextures.com to hit the groun running. go over to the Files link, and download two sample files CopyToWkbk.xl and ExtractUnique.xls. you could tweak and combine the two to get a cod which fits your requirement -- icestationzbr ----------------------------------------------------------------------- icestationzbra's Profile: http://www.excelforum.com/member.php...nfo&userid=458 View this thread: http://www.excelforum.com/showthread.php?threadid=26354 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that copies range to new sheet
Try this example (last macro)
http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Jeff" wrote in message om... I'm trying to get a macro to copy rows in column A to new sheets based on the value in row A. I really could use some help! Thanks so much. For example original sheet has the values: Column A, Column B Red, 123 Red, 234 Red, 111 Blue, 124 Blue, 453 Yellow, 234 Yellow, 531 Yellow, 123 ... and the macro makes three new sheets: New sheet1: Column A, Column B Red, 123 Red, 234 Red, 111 New sheet2: Column A, Column B Blue, 124 Blue, 453 New sheet3: Column A, Column B Yellow, 234 Yellow, 531 Yellow, 123 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that copies range to new sheet
Thanks! These worked very well. You helped me save someone about one
day of work / month. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make copies of sheet and name them from list | Excel Worksheet Functions | |||
Can cells be copies automatically to Sheet 2 and Sheet 3 | New Users to Excel | |||
How do I set up an Excel sheet to automatically print 3 copies? | Excel Discussion (Misc queries) | |||
How to Creat multiple copies of sheet | Excel Discussion (Misc queries) | |||
I need a macro that copies that data from one cell on one sheet to a cell on another? | Excel Programming |