VBA to create/rename new tab and update formula reference

[Dcurtis7640]

Hello - I don't know much VBA so I am not sure how difficult this is. I need help with creating/renaming a new tab and adding a formula on a summary tab to reference the new tab. The new tab will be a copy of a "template" but needs to be renamed (either by a popup dialog box or a cell reference.) There is a summary sheet that references the same cells in each tab - with the creation of the new tab, I'd like the formulas on the summary to be copied down to the next row but change the sheet references to the new tab (each row on the summary represents a project.)

 

[dnorm]

Hi Curtis

Have you tried recording your actions in macros? Try that first (the renaming of the sheet will not work the way you want, but we can alter that). When you read through it it will help you understand what bits relate to what you did.

Post the code you have created and that will aid the forum to better understand and help you.

I know this is not the answer you wanted, but it makes things easier for those who can help.