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" wrote in message ...
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.