Changing vaules according to date selected

Hi,

I need help with the following:

I need my spreadsheet user to be able to see where they should be against a target at a set date in time. I have created a drop down with future dates listed. If a user selects next weeks date i need to show that they should have sold x amount of products by that date. can any one help?

Dan

In the combo box, write a code on ComboBox_Change that will write the value to a cell. Then do a lookup based off of that dummy cell.

That is probably the quickest dirtiest way to do it.

I.E.
Private Sub ComboBox1_Change()
Range("C4").Value = ComboBox1.Value

End Sub

=INDEX(B12:B15,MATCH(C4,A12:A15,0),0)

Assuming you have a list of dates in A12:A15 and the projected sales amount in B12:B15. You can change to fit your exact needs.

Hope that helps..
John

I am a bit of a beginner i guess - that was a bit over my head. please can you explain the first bit again but treat me like a 3 year old!

Thanks

Dan