asked on
Update Cell References with New Sheet Names
I have a summary worksheet in a workbook that will be updating with data from many different worksheets. Each time I add a worksheet I will need to add a cell reference on the summary sheet that will update with the worksheet name, even if I make changes to the worksheet name in the future. Is there a formula that I can use for this?
Microsoft Excel
Last Comment
gacto
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
@Thomas Nutsch
To keep you in the loop, this is a follow on from previous question:
https://www.experts-exchange.com/questions/28308329/Using-Cell-Reference-as-Worksheet-Name.html?anchorAnswerId=39691173#a39691173
To keep you in the loop, this is a follow on from previous question:
https://www.experts-exchange.com/questions/28308329/Using-Cell-Reference-as-Worksheet-Name.html?anchorAnswerId=39691173#a39691173
ASKER
Rob H,
works like a charm. thanks for the suggestion.
works like a charm. thanks for the suggestion.
Can you provide a more detailed example if the help on INDIRECT doesn't lead you to the right solution?
Thomas