Sumit Jain
07-18-2013, 11:01 PM
hi all
I wanted some help in automatizing my worksheet names.
Description:
I have a workbook with multiple sheets. The worksheet names should be coming from the cell B1 of the same worksheet:
Moreover, Cell B1 in each sheet should contain names as follows:
A1.01 - Bombay
A1.02 - Delhi
A1.03 - Kolkata
A1.04 - Chennai
where text in red color are variable and will change from case to case.
I am attaching a sample file.
I wanted some help in automatizing my worksheet names.
Description:
I have a workbook with multiple sheets. The worksheet names should be coming from the cell B1 of the same worksheet:
Moreover, Cell B1 in each sheet should contain names as follows:
A1.01 - Bombay
A1.02 - Delhi
A1.03 - Kolkata
A1.04 - Chennai
where text in red color are variable and will change from case to case.
I am attaching a sample file.