December 7, 2021
I have a workbook with data entry sheets and reports. It also includes a bunch of pivots, regular tables, named ranges, formulas, and macros.
The users should be able to manage the data entry, but I want to be able to update the code and provide new reports in the future.
Is it possible to split the "database" sheets into a separate workbook than the reports and macros?