Hi,
I saw few codes on the net but it didn't work fine for me hence thought of dropping in a note here. Any advise/tip would be of great help
Im looking for a macro that will help me combine multiple workbooks into a New workbook and which can get save on my sharedrive with new name
Bascially, in the morning we run reports for 4 regions (HK, TOK, ASIA,LON) and save the file with todays date. So for example: "Tok 2014-08-26.xls" would be the file name for the Tok region. End of the day I need to combine all of these 4 regions data into a new report all togther. This new report is called as "Daily Reports 2014-08-26.xls"which contains 4 new tabs in the sheet. (i.e the data from HK, TOK, ASIA,LON tabs)
I need a VBA that once clicked can help me create my new sheet ie "Daily Reports 2014-08-26.xls" and than gets saved in our Share drive.
Thank You
I saw few codes on the net but it didn't work fine for me hence thought of dropping in a note here. Any advise/tip would be of great help
Im looking for a macro that will help me combine multiple workbooks into a New workbook and which can get save on my sharedrive with new name
Bascially, in the morning we run reports for 4 regions (HK, TOK, ASIA,LON) and save the file with todays date. So for example: "Tok 2014-08-26.xls" would be the file name for the Tok region. End of the day I need to combine all of these 4 regions data into a new report all togther. This new report is called as "Daily Reports 2014-08-26.xls"which contains 4 new tabs in the sheet. (i.e the data from HK, TOK, ASIA,LON tabs)
I need a VBA that once clicked can help me create my new sheet ie "Daily Reports 2014-08-26.xls" and than gets saved in our Share drive.
Thank You