Filer and Copy

I need to figure out how to filter and copy exactly (all formats) to another
ws within the same workbook. It also needs to know to paste it after the last
row data (Which is basic statement that need to appear within the ws along
withthe pasted data). The number of rows with change. However, I want to
assign the macro to a button. So, everytime the original ws is update. THe
user can initate macro via button to file in the page with information.

Hi Curt

You can find a example here to start with
http://www.rondebruin.nl/copy1.htm

Post back if you need more help

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Curt" <[email protected]> wrote in message news:[email protected]...
>I need to figure out how to filter and copy exactly (all formats) to another
> ws within the same workbook. It also needs to know to paste it after the last
> row data (Which is basic statement that need to appear within the ws along
> withthe pasted data). The number of rows with change. However, I want to
> assign the macro to a button. So, everytime the original ws is update. THe
> user can initate macro via button to file in the page with information.

Hi Ron,

It's definitely a start. However, I need to filter by a specific criteria
and copy only the rows that meet it.

"Ron de Bruin" wrote:

> Hi Curt
>
> You can find a example here to start with
> http://www.rondebruin.nl/copy1.htm
>
> Post back if you need more help
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Curt" <[email protected]> wrote in message news:[email protected]...
> >I need to figure out how to filter and copy exactly (all formats) to another
> > ws within the same workbook. It also needs to know to paste it after the last
> > row data (Which is basic statement that need to appear within the ws along
> > withthe pasted data). The number of rows with change. However, I want to
> > assign the macro to a button. So, everytime the original ws is update. THe
> > user can initate macro via button to file in the page with information.
>
>
>

See
http://www.rondebruin.nl/copy5.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Curt" <[email protected]> wrote in message news:[email protected]...
> Hi Ron,
>
> It's definitely a start. However, I need to filter by a specific criteria
> and copy only the rows that meet it.
>
> "Ron de Bruin" wrote:
>
>> Hi Curt
>>
>> You can find a example here to start with
>> http://www.rondebruin.nl/copy1.htm
>>
>> Post back if you need more help
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>> "Curt" <[email protected]> wrote in message news:[email protected]...
>> >I need to figure out how to filter and copy exactly (all formats) to another
>> > ws within the same workbook. It also needs to know to paste it after the last
>> > row data (Which is basic statement that need to appear within the ws along
>> > withthe pasted data). The number of rows with change. However, I want to
>> > assign the macro to a button. So, everytime the original ws is update. THe
>> > user can initate macro via button to file in the page with information.
>>
>>
>>