Autopopulate cell name with tab name
Hi,
Try:
=MID(CELL("Filename"),FIND("]",CELL("Filename"))+1,31)
or shorten Jacob's suggestion to
=REPLACE(CELL("Filename"),1,FIND("]",CELL("filename")),)
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Neall" wrote:
I have about 100 tabs each signifying a customer profile what I need now is
to automatically take the worksheet name (customer number) and give a cell
that name so cell 1A would have a name of 123456
The reason I need to do this is because I am using a template for all tabs
and as long as this one variable in the template changes to reflect the
customer number then each sheet will work independently when I do a full
update of all sheets.
Any suggestions?
Thanks in advance
--
Neall
--
Neall
|