rainmaker1011
New Member
- Joined
- Jan 2, 2023
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
Hi,
I would appreciate if you could help me with this.
I have a master excel workbook with multiple sheets:
"DATA", "INPUT", "NOTES"
DATA sheet is nicely formatted table with data and formulas referencing to INPUT and NOTES sheets.
DATA has a column A called "Manager". Values are names of managers.
I need to create new workbook for each Manager, and the new workbook should include
DATA, INPUT and NOTES sheets while in the DATA sheet should include the nicely formatted table, with all formulas intact but only the rows where Column A = manager name.
Then I need to name the workbook using the manager name and pass protect each workbook (same password) and save it on my drive.
Example:
Manager name = Peter, there are 10 rows with data with Manager name = Peter.
New workbook will be named Peter and it will include the sheets; DATA sheet will show the 10 rows.
----
I found macro that creates workbook from filtered data, but the process of filtering is manual. I have more than 150 different names that I need to filter so I need to automate that.
Thanks
I would appreciate if you could help me with this.
I have a master excel workbook with multiple sheets:
"DATA", "INPUT", "NOTES"
DATA sheet is nicely formatted table with data and formulas referencing to INPUT and NOTES sheets.
DATA has a column A called "Manager". Values are names of managers.
I need to create new workbook for each Manager, and the new workbook should include
DATA, INPUT and NOTES sheets while in the DATA sheet should include the nicely formatted table, with all formulas intact but only the rows where Column A = manager name.
Then I need to name the workbook using the manager name and pass protect each workbook (same password) and save it on my drive.
Example:
Manager name = Peter, there are 10 rows with data with Manager name = Peter.
New workbook will be named Peter and it will include the sheets; DATA sheet will show the 10 rows.
----
I found macro that creates workbook from filtered data, but the process of filtering is manual. I have more than 150 different names that I need to filter so I need to automate that.
Thanks