My request is twofold.
1. I keep a large spreadsheet of daily purchases made by each of our departments. The department name is in Col F of my spreadsheet. Each morning I make a workbook with all of the previous day's purchases broken out in tabs by department. On any given day there can be anywhere from 15 to 35 different tabs needed. So far, I've just been using a pivot table to make the tabs, but it's getting old. I've recorded a macro that creates the tabs from a pivot, but it only works when the department names are consistent. On those days when the number of departments spike (usually on Mondays), I have to go back to creating the tabs manually. I'm quite a newbie at exploring the potential of macros, and was hoping that someone might be able to help me with a macro that will create my tabs for me regardless of the # of departments involved.
2. Each tab needs to be named based on the manager of that department, and so I've created a reference table where the Department name is in col A and the Manager (and therefore tab) name in Col B. Example, Department name would be "Production" and the tab name would be "Roberts". Unfortunately, I cannot change the main spreadsheet col F to show Manager name as opposed to Department.
Any direction that you can give would be a huge time saver and greatly appreciated!
1. I keep a large spreadsheet of daily purchases made by each of our departments. The department name is in Col F of my spreadsheet. Each morning I make a workbook with all of the previous day's purchases broken out in tabs by department. On any given day there can be anywhere from 15 to 35 different tabs needed. So far, I've just been using a pivot table to make the tabs, but it's getting old. I've recorded a macro that creates the tabs from a pivot, but it only works when the department names are consistent. On those days when the number of departments spike (usually on Mondays), I have to go back to creating the tabs manually. I'm quite a newbie at exploring the potential of macros, and was hoping that someone might be able to help me with a macro that will create my tabs for me regardless of the # of departments involved.
2. Each tab needs to be named based on the manager of that department, and so I've created a reference table where the Department name is in col A and the Manager (and therefore tab) name in Col B. Example, Department name would be "Production" and the tab name would be "Roberts". Unfortunately, I cannot change the main spreadsheet col F to show Manager name as opposed to Department.
Any direction that you can give would be a huge time saver and greatly appreciated!