Macro - Copy current tab to new workbook

[roycettu]

I have two files saved.

2011 rolling 12.xlsx
2011 Budget rolling 12 updater.xlsx

I'm trying to write a Macro and struggling

I am building the macro within the 2011 Budget rolling 12 updater.xlsx workbook. I will have the PL tab displayed. This spread sheet has multiple tabs.
1. I need to run the macro and it will copy cells from A1 to R315 of the 2011 Budget rolling 12 updater.xlsx workbook PL tab

2. I need it to auto create a new tab in 2011 rolling 12.xlsx workbook and name it the tab cell contents of C1 of the 2011 Budget rolling 12 updater.xlsx PL tab.

3. Paste the copied contents - Values only to A1 in the newly created tab


Or something of the sorts. It could save me hours of copy and pasting
Thank you

[JBeaucaire]

Something like this will do it, this macro goes into the updater book, make sure you save it as a .xlsm file or the macro will get deleted.

Please Login or Register  to view this content.