I have a pivot table filtered by "Pozo", showing me those values for each Pozo historically. Next to it, I have a regular table with formulae (referring to the data in the PT) to evaluate the evolution of these parameters up until today, updated daily. One of these formulae calculates the percentage of energy remaining (today's value) compared with the first datum.
Next step is I need to report daily the state of the Pozo, including the evaluation, so I end up updating the database, then manually scrolling through every Pozo and copying the last row.
Can someone give me a hint of some way to automatize these steps? Meaning copying the last row including the results of the formulae, paste them as values somewhere else, then changing to the next item in the "Pozo" Pivot Field, and repeat for all? (I'm thinking VBA but can't get it to work).
