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


On Thu, 14 Oct 2010 13:14:16 -0700 (PDT), Mikhail Bogorad
<(E-Mail Removed)> 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

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

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


Gord

On Thu, 14 Oct 2010 14:15:46 -0700, Gord Dibben <(E-Mail Removed)> wrote:

>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
><(E-Mail Removed)> 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

On Oct 14, 5:15*pm, Gord Dibben <phnor...@shaw.ca> wrote:
> 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
>
>
>
> <mikhail.bogo...@gmail.com> 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- Hide quoted text -
>
> - 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

On Oct 14, 6:22*pm, Gord Dibben <phnor...@shaw.ca> wrote:
> For filtering and automating see Ron de Bruin's site for code and a sample
> workbook.
>
> http://www.rondebruin.nl/copy5_2.htm
>
> Gord
>
>
>
> On Thu, 14 Oct 2010 14:15:46 -0700, Gord Dibben <phnor...@shaw.ca> wrote:
> >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
> ><mikhail.bogo...@gmail.com> 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- Hide quoted text -
>
> - Show quoted text -

Thanks!!!