Plutothedog
New Member
Hi,
i am trying to see if there is a way to auto create workbooks in excel based on the value in a particular column. for example i have a worksheet with 5500 records that are devided in 10 managers. each row has a name of the manager that aligns with it. I wanted to see if there is a way to automate creating of the worksheet based on the manager name.
Currently i have to filter by the manager copy that data and paste it in another tab manually. All of your help is greatly appreciated.
Thank you,
i am trying to see if there is a way to auto create workbooks in excel based on the value in a particular column. for example i have a worksheet with 5500 records that are devided in 10 managers. each row has a name of the manager that aligns with it. I wanted to see if there is a way to automate creating of the worksheet based on the manager name.
Currently i have to filter by the manager copy that data and paste it in another tab manually. All of your help is greatly appreciated.
Thank you,