Dynamic Pivot Lookups

[juliane.kaden]

Hi all,

I have the following issue:

- Got a long list of prices that gets updated every day, ie. adding new lines containing price, trader, and time information every day.
- I currently created a pivot that I manually update to show each day's information, I then manually look up the following.

a) the highest price per item and who was the trader
b) update the price, date and trader information in a separate table that then shows price, dealer and date of last trade at that price.

Is there a way to automate this process?

Thanks!