Skip Rows in Fill Series and Filter to Two different sheets

  • Thread starter Thread starter Benjamin
  • Start date Start date
B

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?
 
Hi,

I would apply an AutoFilter, then select the results and copy the data to
another sheet. Repeat the process for the other criteria.
 
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?
 
Back
Top