Is it possible to create a set of workbooks (each containing a set of 4 worksheets) in a group or library?
The idea is to be able to assemble sets/groups/libraries of workbooks (required for projects) from a common source using macros in another worksheet to add each workbook - these exist already - to a new set in the excel application - not in a folder as that would require a new set of macros to point the assembled workbooks at the folder every time we started a new project.
I would welcome any advice as searches on the web are confusing.
The idea is to be able to assemble sets/groups/libraries of workbooks (required for projects) from a common source using macros in another worksheet to add each workbook - these exist already - to a new set in the excel application - not in a folder as that would require a new set of macros to point the assembled workbooks at the folder every time we started a new project.
I would welcome any advice as searches on the web are confusing.