More Excel help please!

[HumanShield]

I will try to explain as best i can!

I have a drop down box which a user can select a month, and in the column to the left of this there is a list of dates.

I would like this list of dates to show as follows:

01/03/2006
02/03/2006
03/03/2006

and so on to the end of the month. Is there any way i can get these cells to change automatically so when the user selects april, it changes the 03 to 04?

 

[chris06]

Ive just had a play around with this and figured a way of doing in using the Offset and Match formulas. (There may be an easier way that i dont know of though)

Ill send you a copy of the workbook to the address in your trust as its would be quite hard to explain how I did it.

Any questions just let me know.

 

[HumanShield]

That was fantastically helpful, thanks!

 

[chris06]

No problem