Seeking help creating Automatic updating workbook

Hello all,

I'm seeking help creating a workbook that takes information that is massively input in one worksheet, into an automatically updating table in another worksheet. The main goal of this is to have an easy to use tool for my manufacturing company to use to see filtered employee data. I want to create a document that automatically filters the data so all I have to worry about when teaching somebody else to use it, is that they input data into the correct cells on the first worksheet.

The columns that they will input data are labeled: Order #, Confirmation #, Personnel #, Work Center, Entered by, Yield.

The data here will be copy and pasted from SAP so Personnel #'s will be on the list multiple times.

I would like to be able to just copy and paste data from SAP into an excel sheet under these columns and have it filter into a table that shows each 'Personnel #' one time followed by a count of how many times that Personnel # occured, then a total sum of the Yield column that corresponds that that Personnel # all in one line.

Essentially we'd input up to 1000 lines of data into the first worksheet, but there would only be 20 unique personnel #'s. I'd like to be able to filter that 1000 lines into a table of Unique #'s and have all of the data linked to that Personnel # added up nicely.

The issue i'm running into, is that we won't know which Personnel #'s will be in the first worksheet, or how many different unique #'s there will be. Is there a way to automatically sort and filter changing data like this?


Thanks in advance!

Thanks for the reply!

Is there a way I could have it automatically update, without having the user hit alt+f5?

And is there a way to have the pivot table automatically generate if the data is copy and pasted into a certain spreadsheet without having to reselect the columns and create a pivot table each time?