VBA to Rename Worksheets Based on Contents in Sheet 1

[rcschmidt88]

Hello everyone,

This is my first time posting on here, and I'm very new to Excel VBA code, so I would appreciate some help. I have an Excel workbook with 7 sheets. The 1st one is a reference sheet titled Allocation, where I type in names of accounts into cells A3:A5. For the purpose of this question, lets say A3 is Red Account, A4 is Blue Account, and A5 is Yellow Account.

Here are the names I would like for the sheets:
Sheet 2: Red Account Sell Proposal
Sheet 3: Red Account Cost Basis
Sheet 4: Blue Account Sell Proposal
Sheet 5: Blue Account Cost Basis
Sheet 6: Yellow Account Sell Proposal
Sheet 7: Yellow Account Cost Basis

So basically for each account named in A3:A5, I would like 2 sheets, one for sell proposal and one for cost basis. I would like these name changes to be based on changing the text in cells A3:A5 of sheet one. So if I changed "Red Account" in cell A3 to "IRA", then I would want to change sheet 2 to "IRA Sell Proposal" and sheet 3 to "IRA Cost Basis". If you could please be specific about where to paste the VBA code as well, that would be great.

Thanks a ton!

 

[rcschmidt88]

Wow! I just made that correction and it worked! I've been working on this for days and watched countless videos to no avail, so I'm very appreciative that you spent the time to specifically help me.

 

[mumps]

You are very welcome.