Help with Macro copy/past sheet to sheet
 

I am trying to create a macro that will copy the dynamic range of cells from
sheet 1, cell A2(stays constant), to column G, rows will vary by day....then
copy to sheet 2 to the row after the last data row, then format font size 8.
I haven't been very successful with this. Please help!!!

Thanks!

Help with Macro copy/past sheet to sheet
 

Hi Tasha

Start here
http://www.rondebruin.nl/copy1.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tasha" wrote in message ...
I am trying to create a macro that will copy the dynamic range of cells from
sheet 1, cell A2(stays constant), to column G, rows will vary by day....then
copy to sheet 2 to the row after the last data row, then format font size 8.
I haven't been very successful with this. Please help!!!

Thanks!