200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Is it possible to get a pivot table for each reviewer (1-8) that also will show what was (Cleared, Changed, No change) and for each date. This would be for the pivot tab.
And is it possible to have this chart update when new data is added in the Reporting Tab.
You are asking two questions in one thread which hides the fact that both are not to the point. The answer to both questions is yes but because they aren't to the point that answer doesn't help you. Try using the word "how" in your questions.
Building a fairly advanced project, as you seem to be at, your starting point is the end result. That would be the table you wish to show to 8 different viewers. Logically, this should be a template showing different data for each viewer, all in the same format. You should design this template and post it with every question.
From the final output (above) you move to the design of the data tables. Your data must be in such a format that they can be extracted easily to the template. In this stage of the planning you decide which columns you need, possibly more than shown in the template. Observe that you approached your project in the opposite direction. That is a common error but strikes you harder because of the high demands you seem to put on the final output. Again: since your demands are on the output, start with the output.
Once you have both a data source and a data destination you may have a lot of questions, all starting with "how". How do you get the data into the data tables (data entry) and how do you get them into the template (cell by cell). Obviously, all these questions must have a working version of the data table attached. It should be sanitised and may be abbreviated but it must be fully functioning.
Now, you seem to have decided to create a pivot table to take the place of a template. That may be possible but bear in mind that, by deciding on the method, you limit options. Usually, it is better to make decisions after an answer has been received. Anyway, if you don't design the pivot table yourself nobody will do it for you, and if you post only an extract from your data table don't expect it to be even possible to do.
Obviously, you are stuck at the point you should have started at, to wit, the template design. I suggest that you design that to perfection and then ask how to link it to the data tables you also design. Perhaps someone will suggest to use a pivot table but if you want to show different data to different people filtering comes to mind first - perhaps as an intermediate step. No answer is possible without seeing the data in their full and complete glory - meaning all columns and their cell formats - and a full design of the intended output.
