Auto rename tab
Anyone have a clue how to automatically rename sheet tabs to a name in a cell in another tab?
So, if sheet 1 in A2 has the Value "OAC-125" then the following tab names would be updated with that name as follows:
Sheet 2 - Current Name: DAR Updated to: OAC-125 DAR
Sheet 3 - Current Name: ZKL Updated to: OAC-125 ZKL
you get it ha? I thought maybe some formula can be entered with the concatenate symbol in each tab like this:
Sheet 2 - Sheet 1! A2 & DAR
Any idea guys/gals? thank.s
|