Skip Rows in Fill Series and Filter to Two different sheets

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?
 
S

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

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?
 

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

Similar Threads

Filter zeros from two columns, maybe on different rows 2
Match and Copy to Next Sheet 2
Macro to copy value in field and insert it into filter 2
Copy data into sheets 13
Index Match to add employee number 2
Importing fields from separate excel sheets to fill in info in dba 3
Matching values in different sheets and rows 1
SumIF to summarize amount in different sheets by date 4

Top