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
 
Back
Top