How to move rows from one sheet to another sheet (macro)

  • Thread starter Thread starter Stacey
  • Start date Start date
S

Stacey

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.
 
Just use Autofilter. Filter the classification you want, then copy the
visible cells to the corresponding sheet.

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MACRO for moving rows from one worksheet to another 3
Copy data from one worksheet to another 1
How to filter rows data based on background color of individual cells 1
Need a Macro to combine 1-5 sheets in one sheet 1
Merge Multiple workbook sheets into one workbook 0
Moving data from one sheet to another 2
Conditional formating-change color of cells over than one with for 4
copy rows from one Data sheet to another sheet based on cell conte 2

Back
Top