Hello:
I am using VB Macro Code attached to paste certain range of data from closed excelworkbook named
"01_2013.xls" to current open excel file Called "2013_Yearly.xls", in sheet called "Jan13".
"2013_Yearly.xls will have sheet for all 12 months, Jan13,Feb13,Mar13.....Dec13
To do this I open 2013_Yealy.xls file and go to Jan13 tab and run the above macro and it works fine.
I will have monthly .xls sheet as "02_2013", "03_2013", etc
I want to see if it is possible to have the attached macro modified so that
when i open 2013_Yearly.xls file and go to let us say Feb13 tab to run the above macro.
Once i run the macro, the source file name in the code should automaticaly change to "02_2013.xls" for Feb and destination should change to Feb13 in the code
Basically i wan to use one macro to perform for all 12 months rather then creating macro for each month.
I hope this is clear and looking forward for quick help
As always thank you for your help in advance.
Riz
Bookmarks