I have a workbook with multiple sheets. Each sheet has a title (just words in a cell). Is there VBA formula that will have the sheet take the name of the title and also chnage when the title name changes? Thanks
Well, since you haven't really described any details about where the "title" is stored, we've just been guessing that it's in the cell A1.
And also, we don't know "how" that cell changes. Is that cell a formula or do you change it by hand?
So please give some more details of exactly what you want to accomplish
Cell A1 is correct. The title for each sheet is in cell A1 but part of the title is coming from a different. For example the formula of cell A1 of one sheet looks like this :
="Task Tracker for "&'READ ME!'!A16
The actual title of that sheet is Task Tracker for Property A. The Property A part is coming from &'READ ME!'!A16, which is another sheet and the cell in that sheet. Property A is the only thing that would be changing in the title and in order to change it I would go to the sheet called Read Me! and changed it there. It then automatically changes cell A1 in the other sheet to whatever I changed it to. So my goal is to also get the corresponding sheet name to change. Looking at it now, the sheet name is currently titled just Property A, so if there is a way I could link the sheet name to the correct cell from the Read Me! sheet, that would work better. All of the sheets relate back to the sheet called Read Me. (I did not make up this workbook, someone else did and I am trying to help them out).