Forum Discussion
Solved
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 ...
Oops - the code still depended on the name "TEMPLATE"at one point. I have corrected it.
See attached version.
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.
- This works perfectly for Question 1. Thank you very much.
Any idea on Question 2?See the attached sample workbook. You'll have to allow macros.
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.
