VBA Rename 2 sheets from cell values from non-active sheet

I would like to be able to add a feature to a template I am designing for another user. There are 2 worksheets that I would like to be able to be renamed, both will contain the date in cell I1 on the "Main" tab (sheet2). I1 is a date in the format of mmm dd yyyy. Each of these 2 sheets also requires text also. I would like the macro to be able to work regardless of what the current sheet name actually is... just in case the end user does something manually.


sheet3: ALL as of I1
sheet4: METRO as of I1

For example, cell I1 on Main = Feb 1, 2019

sheet3: ALL as of Feb 1 2019
sheet4: METRO as of Feb 1 2019

I found some dynamic renaming based on the cell value (A1 for example of the same sheet), or VBA with the active sheet. However these are payroll records I am working with, so I cannot modify these tabs to add another row as they will be imported into another system. I need to be able to rename both these sheets from another sheet to make this work.

Thanks in advance for your help!!!!

Try:

Please Login or Register  to view this content.

PERFECT!!!!!! That is exactly what I needed Mumps1!!!! tysvm! I greatly appreciate your help on this one! Thanks again!

You are very welcome.