Excel 2007 macro to copy tab to another workbook
Posted on 2011-04-20
I have a semi-automated report which I'm soooo close to making fully automated, it's just down to saving the file correctly, and here's where I need some advice.
I have a file called Template.xlsm, which is opened daily via task manager. It uses a macro to auto-update data from a few sources, & format a report. Then it renames the report tab to the day number of the month.
What I want to do now is the following:
Copy the report tab to the end of an existing monthly file located on a remote server \\host\folder ( I have this mapped as well x:\folder)
The report folder already contains the base information and monthly file, I just need the tab added at the end.
The existing reports are named "Report YYYY_MM.xlsm"
How can I get the macro to copy that tab to the correct monthly file?
The idea is that I'll end up with a file for each month that has 28-31 numbered tabs, plus some summary stuff at the beginning of the workbook that was added ahead of time