AutoFilter for each status on sheet1 then copy to appropriate sheet.

I am sure there is more to this than you have described.

Sheet1 data dump is being updated frequently?

Does the new dump overwrite the previous dump?

What is source of data dump?

You want new records to be appended to exiting records on each of the
destination sheets?

Do you want this automated?


Gord Dibben MS Excel MVP


On Thu, 14 Oct 2010 13:14:16 -0700 (PDT), Mikhail Bogorad
wrote:

Hi,

i have a kind of a data dump on Sheet1 that contains all records.
Column "I" has the latest record status.
Statuses are as follows: Submitted, Incomplete, Pending, Paid.

So what i want to do is to copy Submitted records into "Submitted"
worksheet, Incomplete ones into "Incomplete" sheet and so on.

Thanks