I have a list of Data in an access data base. I am linking a pivot table to this list in excel.
For each historical date there are a number of prices released on that day. I would like to create a link from the pivot table to another sheet. But I would only like to PULL THE MOST REENT PRICES. (recent by date).
Any ideas?