copy/paste records into different sheets by status

[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

 

[Gord Dibben]

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

 

[Gord Dibben]

For filtering and automating see Ron de Bruin's site for code and a sample
workbook.

http://www.rondebruin.nl/copy5_2.htm


Gord

 

[Mikhail Bogorad]

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 -

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

 

[Mikhail Bogorad]

For filtering and automating see Ron de Bruin's site for code and a sample
workbook.

http://www.rondebruin.nl/copy5_2.htm

Gord













- Show quoted text -

Thanks!!!