I am developing an excel workbook to track retirement funds. Each worksheet
represents a separate fund. The last worksheet contains a summary of the
various funds including latest unit price, number of units, etc. From each
worksheet (fund) I want the workbook to find the most recent entry (from the
date column) & corresponding unit price (from the price column on the same
row) & transfer this information to assigned cells in the summary sheet.
What function/programming is required to make this work?