Changing Sheet Names based on a Cell Reference

Hi all,

I'm trying to connect two excel files by using VBA. First, I'm copied a sheet named "Template" from File 1 to File 2 and inserted a new sheet and copied the information again from the sheet named "Template" to this new sheet using a recorded macro (I'm very new to VBA/macros so I'm sure this could be simplified but I'm happy just to have gotten it to work). However, now I want to rename this new sheet based on the contents in cell B2.

Each new sheet will have different values in cell B2 (2012-1, 2012-2...etc.) and I want to write some code that will easily change the sheet names for me without renaming each tab. There will be potentially 100+ tabs so I would be very time consuming to do so. Does anyone have any thoughts?

Thanks,

Tom

tjloggia,

Give this a try:

Please Login or Register  to view this content.

Please Login or Register  to view this content.