Skip Rows in Fill Series and Filter to Two different sheets
 

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?

Skip Rows in Fill Series and Filter to Two different 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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Benjamin" wrote:

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?

Skip Rows in Fill Series and Filter to Two different sheets
 

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?

"Shane Devenshire" wrote:

Hi,

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Benjamin" wrote:

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?

Skip Rows in Fill Series and Filter to Two different sheets
 

Hi,

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Benjamin" wrote in message
...
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?