MACRO for moving rows from one worksheet to another

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. 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.
 
F

Fred Smith

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
 
S

Stacey

Thanks, but that will not work, because it is conditional on what rows to be
moved based on the formulas in the first row.
 
F

Fred Smith

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
 

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

Top