Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO for moving rows from one worksheet to another
I have a workbook that has different classifications based on a dates
(Classifications = Red, Green, Yellow). On the cumulative sheet I have all and then I have a separate sheet for each class. Using macros I want to copy the rows (B-M) that contain the class to its corresponding sheet (keeping the cumulative sheet populated). I have a formula to notate which row contains the appropriate color (Column A). Each sheet has the same header as the cumulative sheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO for moving rows from one worksheet to another
The most effective way is to create your own macro. Turn on the macro
recorder, go through the steps to copy your data, then turn it off, and save the macro. Voila, a macro you can use as often as you want. Regards, Fred "Stacey" wrote in message ... I have a workbook that has different classifications based on a dates (Classifications = Red, Green, Yellow). On the cumulative sheet I have all and then I have a separate sheet for each class. Using macros I want to copy the rows (B-M) that contain the class to its corresponding sheet (keeping the cumulative sheet populated). I have a formula to notate which row contains the appropriate color (Column A). Each sheet has the same header as the cumulative sheet. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO for moving rows from one worksheet to another
Thanks, but that will not work, because it is conditional on what rows to be
moved based on the formulas in the first row. "Fred Smith" wrote: The most effective way is to create your own macro. Turn on the macro recorder, go through the steps to copy your data, then turn it off, and save the macro. Voila, a macro you can use as often as you want. Regards, Fred "Stacey" wrote in message ... I have a workbook that has different classifications based on a dates (Classifications = Red, Green, Yellow). On the cumulative sheet I have all and then I have a separate sheet for each class. Using macros I want to copy the rows (B-M) that contain the class to its corresponding sheet (keeping the cumulative sheet populated). I have a formula to notate which row contains the appropriate color (Column A). Each sheet has the same header as the cumulative sheet. . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO for moving rows from one worksheet to another
You select the class you want (ie, Yellow) using Autofilter. Then copy the
visible rows. That gets the bulk of the macro done. Post back if you need help with specific sections after you've created it, but asking someone to write the whole macro for you is outside of the scope of this group. Regards, Fred "Stacey" wrote in message ... Thanks, but that will not work, because it is conditional on what rows to be moved based on the formulas in the first row. "Fred Smith" wrote: The most effective way is to create your own macro. Turn on the macro recorder, go through the steps to copy your data, then turn it off, and save the macro. Voila, a macro you can use as often as you want. Regards, Fred "Stacey" wrote in message ... I have a workbook that has different classifications based on a dates (Classifications = Red, Green, Yellow). On the cumulative sheet I have all and then I have a separate sheet for each class. Using macros I want to copy the rows (B-M) that contain the class to its corresponding sheet (keeping the cumulative sheet populated). I have a formula to notate which row contains the appropriate color (Column A). Each sheet has the same header as the cumulative sheet. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, how do I add more rows to the worksheet? Tried moving . | New Users to Excel | |||
Macro for Moving rows | Excel Discussion (Misc queries) | |||
Moving data from one worksheet to another via a Macro! | Links and Linking in Excel | |||
Make a Macro take out rows and add it to new worksheet | Excel Discussion (Misc queries) | |||
Macro for moving rows? | New Users to Excel |