| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Workbook, Data Selection by Date
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 VBA Range selection based on system date | Excel Discussion (Misc queries) | |||
| Code to send email to address within selection in Excel workbook | Excel Discussion (Misc queries) | |||
| RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DATE | Excel Worksheet Functions | |||
| Set a cell to have a pop-up calendar for date selection in Excel? | Excel Worksheet Functions | |||
| How do you create a selection box for data entry within excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
