/ Sign-up
Your question

Grouping excel workbooks

  • Configuration
  • Macros
  • Excel
  • Windows 7
Last response: in Windows 7
July 15, 2011 8:29:11 AM

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.

More about : grouping excel workbooks

July 15, 2011 6:36:05 PM

I second this question. The web searches are very confusing. i understand how to group them using shift, but is there anyway to create sub tabs at the bottom of the workbook?