copy/paste records into different sheets by status

  • Thread starter Thread starter Mikhail Bogorad
  • Start date Start date
M

Mikhail Bogorad

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






- Show quoted text -
Click to expand...

I want to keep it as a template, just copy the dump into Sheet1 and
run a subroutine to do all shuffling. All sheets will be kept empty
except for row 1 -titles
 
Back
Top