sswcharlie
12-14-2012, 04:44 PM
I have a line of code that copies the daily report and places in a archive for that month. A new sheet created for each month using Month/Year for the tab. All works ok new sheet set up, except that I have not worked out how to change the ref in the line below from ("Nov2012) to the next month ("Dec2012). This so that the copies for Dec wil go in the Dec sheet.
Sheets("DailyList").Range("DailyCopy").Copy
Destination:=Sheets("Nov2012").Range("C" &
Rows.Count).End(xlUp).Offset(7)
End Sub
In the line it needs something like..... =sheets(=date mmmyyyy).Range...
AmI getting close ?
Any comments would be appreciated.
Thanks
Charlie
Sheets("DailyList").Range("DailyCopy").Copy
Destination:=Sheets("Nov2012").Range("C" &
Rows.Count).End(xlUp).Offset(7)
End Sub
In the line it needs something like..... =sheets(=date mmmyyyy).Range...
AmI getting close ?
Any comments would be appreciated.
Thanks
Charlie