| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Workbook, Data Selection by Date
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? |
| 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) | |||
Threaded Mode
