Is there a way to use workbooks like modules, open one to do a certain task, and use those results in a current workbooks that access many modules? If so what is the best way to do that?
Basically, create a workbook to look and function exactly how you want it to. Do not place any data in this 'master workbook' except for data
that will constantly be the same for all other workbooks you create.
Give this "copyable" (not certain that is a word but you get the idea) workbook a distinctive name for easy reference in the future.
When needed you can "save" the workbook with a new name, in a folder you select, then add new data as needed. When you 'save' this
master workbook before you add any data to it, you are not modifying the master .... you'll be creating a saved version in another location.
