Is it possible to take a spreadsheet and create a new workbook and sheets using a macro? I'm trying to create a new workbook based on "Originating Department" in the base spreadsheet.
The new workbook would have a tab for the "Originating Department" for an overall view and sheets created for the "CC#" that corresponds to the originating department.
Bookmarks