Returning values with criteria

[goku99]

I have a Pivot Table whose data entry all week is made, having then enormous amount of data. It would like to make a code that it would prevent to store all the previous data and when it brought up to date only to record the entrances of that day (the data of the previous days already would be recorded, and the news given could be recorded on of the previous one). My dynamic table would be like this:

Criterion 20

Mounth/Day
Mai/6 Mai/7


Name
Alex 700
Ricardo 900
Roberto 600
Saul 100 800
Paulo 300
Daniel 400
Jose 500 350


With the Filter of Report "Criterion", I would like to store the fields Name, Month/Day, Value. However, I would like to only store or to visualize an amount X of Month/Day (entered). My Data entry sheet would be like this:


M/Day Criterion Description Name Value
mai/6 85 6 Roberto 150
mai/6 85 6 Alex 90
mai/6 85 6 Saul 2.900,00
mai/6 85 6 Ricardo 90
mai/6 20 6 Saul 100
mai/6 20 6 Paulo 300
mai/6 20 6 Daniel 400
mai/6 20 6 Jose 500
mai/7 85 6 Roberto 450
mai/7 85 6 Alex 140
mai/7 85 6 Saul 4.000,00
mai/7 85 6 Ricardo 11.400,00
mai/7 20 6 Roberto 600,00
mai/7 20 6 Alex 700,00
mai/7 20 6 Saul 800,00
mai/7 20 6 Ricardo 900,00
mai/7 20 6 Jose 350,00

To store the data, I thought about a structure of repetition with function VLOOKUP from the criterion. However, I would not know how to insert a code to only store or to visualize an amount X of Month/Day (entered). Additionally, I would like an auditor, for example: " With criterion 20, how many names were in mai/6, and how many are not more in mai/7? ".


Any aid, I am thankful!