Excel VBA Course
Excel VBA Course - From Beginner to Expert

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.)

View Course

Reporting Pivot


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.



There are two open questions of yours for which you haven't selected an answer. Please deal with the old before you proceed to the new.
Variatus (rep: 4889) Nov 26, '18 at 7:11 pm
I'm so sorry! I appreciate all you do! I have selected those two answers for you.
Sroncey21 (rep: 66) Nov 26, '18 at 7:34 pm
Thank you :-)
Variatus (rep: 4889) Nov 26, '18 at 7:53 pm
Add to Discussion


Selected Answer

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.



That sounds very complex. I'll take the easier of the two options for now and just ask how to do a simple pivot table with what reviewer on what date matched to (changed, no change, cleared)

Hopefully soon I can graduate to an updatable template. 
Sroncey21 (rep: 66) Nov 26, '18 at 8:12 pm
On the Insert tab click Pivot Table. Follow the instructions in the dialog box. After you have the table the way you want, ask how to filter out specific data.
Variatus (rep: 4889) Nov 26, '18 at 9:54 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login