Scenario: I have a workbook with one primary worksheet upon which tabulated calculations occur: this sheet starts as a blank template and ends as a deliverable. Then there are many secondary/support worksheets which contain data that the primary sheet references via vlookup/named ranges (etc). There is also a tertiary object, a range of cells within and below the primary worksheet in which sumifs are executed to total data in the tables above.
Question: Is there a way that the secondary sheets (and the sumifs range) can exist in a reference-only form (infrequent modifications) while the primary worksheet exists in a template form (frequent modifications) such that the template can start as a blank sheet, and then be saved separately from, yet with persisting references to, the reference worksheets?
Purpose: To the end that multiple projects can be processed using the application without duplicating the secondary worksheets. Updates can be made to the secondary worksheets once in the course of a project that has multiple primary sheet instances.
Footnote: This application is an inventory spreadsheet provided by a vendor. I have modified the workbook with my own secondary worksheets to maintain my inventory and reference it from the primary sheet. The vendor makes continuous updates to the primary sheet. I use the vendor's spreadsheet to inventory items across multiple buildings referring to the same inventory. As the workbook exists now once I create more than one file instance I have to update the references on each instance if references change. I would like to be able to swap primary sheets in and out of the workbook containing the secondary sheets without upsetting named ranges.
PS. I hope that is clear enough. Thanks!
Question: Is there a way that the secondary sheets (and the sumifs range) can exist in a reference-only form (infrequent modifications) while the primary worksheet exists in a template form (frequent modifications) such that the template can start as a blank sheet, and then be saved separately from, yet with persisting references to, the reference worksheets?
Purpose: To the end that multiple projects can be processed using the application without duplicating the secondary worksheets. Updates can be made to the secondary worksheets once in the course of a project that has multiple primary sheet instances.
Footnote: This application is an inventory spreadsheet provided by a vendor. I have modified the workbook with my own secondary worksheets to maintain my inventory and reference it from the primary sheet. The vendor makes continuous updates to the primary sheet. I use the vendor's spreadsheet to inventory items across multiple buildings referring to the same inventory. As the workbook exists now once I create more than one file instance I have to update the references on each instance if references change. I would like to be able to swap primary sheets in and out of the workbook containing the secondary sheets without upsetting named ranges.
PS. I hope that is clear enough. Thanks!