Excel Drop down Calendar in Excel 2007

Joined
Jun 30, 2011
Messages
2
Reaction score
0
Hi
I am trying to insert a separate drop down calendar into consecutive cells in a column, so as to reference a different date with the data on each row in a Excel 2007 spread sheet, (the rows of data reflect people and their activities for the day)
I found out on this website how to insert a single calendar with the output linked to a referenced cell e.g. $B$3 but not how to do this for consecutive cells in the column.

Thanks
George
 
Back
Top