Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excell - query
hi!
I am preparing a basic calculator for myself for some funds and I got into a trouble... there is a excel file U can download... http://www.andergrant.com/problem.zip so.. "a, b, c, d, e, f" sheets are the names of funds the problem is in the sheet called 'main' in the cell F109. I want this cell to feedback me the number taken from sheet 'a' from the row number 4 BUT !!! - I WANT IT TO FEEDBACK IT FROM TODAY!!! (I want to query to compare/check today's date and answer with a proper number under the today's date). So the feedback for such a query for today (2004-11-27) should be 5049,92. If today's would be 2004-11-22 the feedback for sheet 'a' would be 5050,11 - I hope U are enable to see it... Please give me a hand with it - I would be very thankfull thx.up front m. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to change the normal excell icon on an excell file? | Excel Worksheet Functions | |||
Excell '03 doesn't Web Query from Yahoo's new portfolios | Excel Discussion (Misc queries) | |||
How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
how do you open an excell email attacment, if I dont have excell | Excel Discussion (Misc queries) | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) |