ExcelBanter - View Single Post

Don

Thanks Max, I will try that.

Don

"Max" wrote:

In your Summary,
with the "fund" sheetnames* listed in A2 down
Try this in B2:
=LOOKUP(2,1/(INDIRECT("'"&$A2&"'!A2:A100")<""),INDIRECT("'"&$ A2&"'!C2:C100"))
Copy down to return the latest** prices from col C in each fund's sheet.
Adapt the ranges to suit the largest expected extent of data.

*Ensure that the sheetnames listed in A2 down match exactly (except for
case) with what's on the tabs. Watch for typos, extra spaces which might
throw matching off
**Latest prices are assumed the data in col C corresponding to the
"bottomest" date in col A
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Don" wrote:
Thanks Max .... but still having trouble.
Perhaps a bit more discription will help. The fund sheets are similar to
your example (Column A is for dates), however, the unit prices are in Column
C. As for the summary sheet, Column A contains the names of all the funds
(worksheets) & Column C is reserved for the unit prices which correspond to
the most recent entries (dates). The dates are not shown on the summary
sheet.