I have a sheet with lots of formulas and text called TEMPLATESHEET. This sheet is stored in a TEMPLATEWORKBOOK.
When I open any xls file, I want a macro that will insert to the active workbook, the TEMPLATESHEET.
However, the TEMPLATESHEET, has some formulas that refer to a sheet called REFERENCESHEET.
So, when the xls file I open has a sheet with the same name, REFERENCESHEET, I want the formulas for the TEMPLATESHEET to link to the REFERENCESHEET.
Would that be possible? I may have to search-and-replace the #REF of the TEMPLATESHEET to match the REFERENCESHEET, unless the TEMPLATESHEET will preserve the references and have them working.
I don't think there is more info than that available.