Macro that copies current sheet including Formulas macro & rename new sheet from current open sheet

N

NiobeOrb

New Member
Joined
Jul 30, 2013
Messages
2
Hello,

I have a worksheet that will serve as the template for a "carry-forward" workbook. I have played around, and I can create a macro to copy the sheet "WE 07.26.2013" (which is a copy of the "template" sheet that has no formulas), but my formulas on the "WE 07.26.2013 (2)" worksheet still look to "template" and I need them to look at the previous sheet. Obviously my macro is simply copying the "template" and not the current sheet. Also the copied sheet does not carry forward the macro.

Can I do what I am looking to achieve, and can I have it rename the new worksheet as a new name, but seven day advance from the last sheet (ex WE 07.26.2013 ----> WE 08.02.2013, etc..), and does this even make sense?

Any help is greatly appreciated.
 
Sort by date Sort by votes
Hello,

I have a worksheet that will serve as the template for a "carry-forward" workbook. I have played around, and I can create a macro to copy the sheet "WE 07.26.2013" (which is a copy of the "template" sheet that has no formulas), but my formulas on the "WE 07.26.2013 (2)" worksheet still look to "template" and I need them to look at the previous sheet. Obviously my macro is simply copying the "template" and not the current sheet. Also the copied sheet does not carry forward the macro.

Can I do what I am looking to achieve, and can I have it rename the new worksheet as a new name, but seven day advance from the last sheet (ex WE 07.26.2013 ----> WE 08.02.2013, etc..), and does this even make sense?

Any help is greatly appreciated.
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Question Question
Copy a template if Master is Yes, rename with cell data
Replies
3
Views
298
Alex Blakenburg
A
T
  • Solved
Copy all sheet contents from selected workbook and paste into current workbook sheets of the same name
Replies
2
Views
261
TurpsUK
T
B
  • Solved
Found a VBA code to rename sheet name as the current date, but now, trying to make this new sheet as the active worksheet.
Replies
5
Views
115
dmt32
D
T
  • Question Question
VBA Stuck Sanitising Several Sheets
Replies
2
Views
280
Tarkemelion
T
R
  • Solved
Copy and Rename Sheet based on cell data
Replies
6
Views
151
DanteAmor
DanteAmor

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top