Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to move rows from one sheet to another sheet (macro)
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. 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
|
|||
|
|||
How to move rows from one sheet to another sheet (macro)
Just use Autofilter. Filter the classification you want, then copy the
visible cells to the corresponding sheet. 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. 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 | |||
I do not want the top rows of a sheet to move when I scroll down | Excel Discussion (Misc queries) | |||
move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
How do I copy or cut multiple rows to move to new sheet? | Excel Discussion (Misc queries) | |||
How to move rows in a Sheet? | Excel Discussion (Misc queries) | |||
make a macro to move specific rows to another sheet | Excel Worksheet Functions |