Forum Discussion
Need help with an "Overview" Sheet
Oops - the code still depended on the name "TEMPLATE"at one point. I have corrected it.
See attached version.
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.
See the attached version. I made the references in the formulas in column C absolute, so that the references will remain the same when the range is copied.
The workbook is .xlsm so you will have to allow macros.
HansVogelaar That worked great. I added an additional row to help separate the overviews a bit and I broke the code. Tried to correct the code to include the additional rows and I broke it...
I'm not sure how this code works so I have to rely on your expertise to fix this. Sorry to ask you a second time, but please take a look and make the correction.
Also, just to clarify, is this code searching for and making a copy of "TEMPLATE"? If I change the title of TEMPLATE to something else, will it still work?
- Also I'm not sure if the placement I have for the "Add Office/Phase" button is okay. Is there a way we can have it move down as new overviews are added? If not, I will find a new location for it to stay.