Place a cell value into the worksheet tab.

[AndyRoo119]

Hi there,
My workbook consists of 12 sheets, one for each month of the year.
I currently have the formula =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) in order to place the value of the worksheet tab into a specified cell.
Is there a way to reverse this, and place the cell value into the tab name?
The values for the tabs and specified cells will only be dates, month and year, one for each month of the year.

Thanks for any help.

[ChemistB]

It would require VBA (programming). Is that acceptable? Is the cell going to have a true date in it or will it be text?

[sandy666]

.
.
.
.
.
Read here: Dynamic worksheet tab name

[AndyRoo119]

VBA would not be a problem, if I knew how to do it!
The cell in question would only contain a date, currently its in the format mmmm yyyy.

[ChemistB]

Copy this modified version of what was on the link Sandy gave you. Then Right click on the sheet tab where you want this to happen and "View Code" Paste this into the text box and close the VBA Editor. Modify the code if the cell where the date will be is not A1.

Please Login or Register  to view this content.

Questions?

[AndyRoo119]

Thanks a lot for that.
As I mentioned to Sandy, I'm going to try and work some sort of loop within the code to go through each of the sheets - January to December.
If I get completely lost I may be back to ask for help again.

Thanks for all the assistance - so far!

[sandy666]

But now you got help for "Place a cell value into the worksheet tab". The rest will be another problem. Right?

[AndyRoo119]

Absolutely Sandy! Working on it at the moment.