Need to "explode" or "copy" information to Other Worksheets in a Workbook

[Ampinz]

Hi Experts!

I need help!

I need to explode information from a main worksheet into individual worksheets within the same workbook. Several individuals are assigned work based from one main worksheet, "Oct-20". The data from certain columns needs to "explode" or "copy" into their individual worksheets. The main driver here is the Name of the person. The name can appear multiple times in the main worksheet and have several different entries. Each Entry needs to populate into the persons individual worksheet.

See images attached.

 

[Bmort]

Why not keep the existing worksheet and have each user filter by their name to see the work that is assigned to them instead of splitting it out to seperate sheets?
This seems to be the simplest solution to me.

If it needs to be in seperate sheets, would that be a permanent solution and everybody's data would always be seperated? Or are you intending to keep separate sheets for each user, and also maintain a "master" sheet with everybody's data? If that is the case then there would be issues keeping concurrency between the master data and the seperate by-user sheets.

 

[Ampinz]

Why not keep the existing worksheet and have each user filter by their name to see the work that is assigned to them instead of splitting it out to seperate sheets?
This seems to be the simplest solution to me.

If it needs to be in seperate sheets, would that be a permanent solution and everybody's data would always be seperated? Or are you intending to keep separate sheets for each user, and also maintain a "master" sheet with everybody's data? If that is the case then there would be issues keeping concurrency between the master data and the seperate by-user sheets.

There has been issues with people filtering and sorting. If they do it wrong, then it skews all the data. Which is what has happened. Thus....the only solution I have is to separate them. But I also realized last night, I can build each tab with their own pivot table, so that may be an option.

 

[Bmort]

Be careful with using pivot tables. The data doesn't automatically update so the user could wind up with stale data in the pivot table. There is an option to automatically update the data in the pivot table when the file is opened. See this link below.

Refresh PivotTable data - Microsoft Support

Manually refresh or update data in a PivotTable that's connected to an external data source to see changes that were made to that data, or refresh it automatically when opening the workbook.

support.microsoft.com