Forum Discussion
Steven560
Jul 24, 2022Copper Contributor
Need help with an "Overview" Sheet
I have a file that I want to use as a template for future projects. Sheet 1 is titled "Overview" and Sheet 2 is titled "Project ABC". I have two questions that I need help answering to complete this ...
- Jul 24, 2022
Oops - the code still depended on the name "TEMPLATE"at one point. I have corrected it.
See attached version.
HansVogelaar
Jul 24, 2022MVP
Re: Question 1.
Yes, use this:
=RIGHT(CELL("filename",'Project ABC'!A1),LEN(CELL("filename",'Project ABC'!A1))-FIND("]",CELL("filename",'Project ABC'!A1)))
If you change the name of Project ABC, Excel will automatically change the reference in the formula.
- Steven560Jul 24, 2022Copper ContributorThis works perfectly for Question 1. Thank you very much.
Any idea on Question 2?- HansVogelaarJul 24, 2022MVP
See the attached sample workbook. You'll have to allow macros.
- Steven560Jul 24, 2022Copper Contributor
HansVogelaar Seems to work in your sample workbook. Can't get it to work on my own. I've attached my workbook for you to play with. Should help you better understand my desire as well. Can you see if you can get this to function?
Thanks.