This has to be in this form somewhere but I must not be wording it in the search correctly. So please point me in the right direction if I am in error.
I currently have a workbook master file that I have to copy at the start of each month to track sales for that month. As part of the change I have to rename the TABS
For example this month is 12.01.11, 12.02.11, 12.05.11 (note that the 3rd and 4th are weekends and have no data so I skip them)
Now January roles around and 01.02.12, 01.03.12 and so on.
I am very new to Macros but I am also confident that a Macro could do this but I cant seem to get off the launch pad here.
If it matters I do have a totals page which does a lot of tab cell referencing ie "=sum('12.01.11:12.30.11'!H44)" That formula obviously changes month to month.
Thanks in advance for any help.
Bookmarks