Date/Lookup/Reference Help

[speth]

I have a calc sheet with several items, but for brevity's sake, I have dates for the entire year listed down Column A, and values corresponding down Column B.

I'm trying to call up a reference from another cell, say C1, that will say either "given XXX date, the Column B value is YYY", where I can input the date that's being searched for in C2, or I can have it reference NOW().

I'm at a loss for this one, not even sure what angle to approach it from. Any suggestions?

 

[JoeMo]

Thanks for Quick reply, Your so great also. May be I bother lot. I am new that why i understand very poor. your reply NO#14 work nicely but reply no#19 not work in my sheet, i coped that another sheet, but when i run it Excel reply Macros box, plz help me

The code in #19 is sheet code not a standard module. Remove it completely then follow the instructions below to install it in your Report sheet.

To install the code:
1. Right-click the worksheet tab you want to apply it to and choose 'View Code'. This will open the VBE window.
2. Copy the code below from your browser window and paste it into the white space in the VBE window.
3. Close the VBE window and Save the workbook. If you are using Excel 2007 or a later version do a SaveAs and save it as a macro-enabled workbook (.xlsm file extension).
4. Make sure you have enabled macros whenever you open the file or the code will not run.

 

[khan_safi773]

Wow, thanks, Mr. JoeMo. it's working now.

 

[JoeMo]

Wow, thanks, Mr. JoeMo. it's working now.

You are welcome.

 

[khan_safi773]

hi Dear JoeMo,
How are you? hope ur fine. i have new problem? some give me an Excel sheet but he put it some micro, but i cannot see it. he put it password. can i remove password with out his help.

plz help me

safi

 

[JoeMo]

hi Dear JoeMo,
How are you? hope ur fine. i have new problem? some give me an Excel sheet but he put it some micro, but i cannot see it. he put it password. can i remove password with out his help.

plz help me

safi

That would violate a Forum rule:
Rule #11:
The policy of this board is NOT to assist with the breaking of passwords under any circumstances. Such posts will be deleted or locked and may lead to a warning.

Additionally, if you have a new need for help from this Forum you should initiate a new post, not piggy-back on an existing one.