Skip Rows in Fill Series and Filter to Two different sheets

[Benjamin]

I've got a fill series of unquie entries.

Col
A B C D
Status xx xx xx

I need to copy the rows to different sheets.
I've got six different status types.
Depending on the status I've got two different sheets two send them to.

How can I fill the two sheets?

 

[Shane Devenshire]

Hi,

I would apply an AutoFilter, then select the results and copy the data to
another sheet. Repeat the process for the other criteria.

 

[Benjamin]

I need this to be automated. So that the Data Entry User
Can screw things up or tinker with it. Could I record I macro to do that
then?
That would work right?

 

[Ashish Mathur]

Hi,

You may want to refer to Question 7 on
http://ashishmathur.com/knowledgebaseII.aspx.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com