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!