Renaming sheets using list on another sheet

[lembi2001]

Thank you for your help with my previous query


My Workbook is taking shape quite well now but I have come across another stumbling block.


The workbook contains a Worksheet called Data and this sheet contains information about sheet names.


The list contains 3 columns (A:C) which detail the sheet name.


Column A is the identifier, a 4 digit code, Column B is a further identifier and Column C is the name of the sheet. What I am trying to do is rename the sheets in my workbook based on their original name.


Example


All the sheets are named as 4 digit codes when they are created
As part of another Macro I have, I want to read the sheet name, find that value in the Data sheet and rename the spreadsheet using the information in columns A B and C


Pseudo Code:


Get Sheet name
Find Sheet Name in Data Sheet
Rename Sheet using DataSheet Row A & " - " & Datasheet row B & " - " & DataSheet Row C


The result would look something like 3091 - U4 - Unit 4


Anyone able to firstly understand my gibberish and secondly help me out??

 

[lembi2001]

Re: Reanming sheets using list on another sheet

Thanks FormR

I'll go back to the drawing board but your code will help me with it no doubt