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.

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" <Stacey@discussions.microsoft.com> wrote in message 
news:5E3E2DA8-D1A1-4A45-BDB4-53722F65F95D@microsoft.com...
>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. 

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" <Stacey@discussions.microsoft.com> wrote in message 
> news:5E3E2DA8-D1A1-4A45-BDB4-53722F65F95D@microsoft.com...
> >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. 
> 
> .
> 

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" <Stacey@discussions.microsoft.com> wrote in message 
news:A4BB881D-EC34-4BC1-A8E9-FAD4E7D9A4AA@microsoft.com...
> 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" <Stacey@discussions.microsoft.com> wrote in message
>> news:5E3E2DA8-D1A1-4A45-BDB4-53722F65F95D@microsoft.com...
>> >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.
>>
>> .
>>