Excel programming help

[Geoff D'Arcy]

I need some help with a workbookI am making. I am fairly capable of most
excel uses, however I am working from someone else's sheet which has a lot
of protected cells and I would like to simply make my own that looks the
same. But I like how he did his "drop down menu" to change the date, so I
need to know how to go about doing that? Would someone have the time to
look over this file and give me an idea how I can recreate this? Thanks.

Geoff

 

[DGP]

To create a drop-down menu in a worksheet:

1) In an empty region of your worksheet enter the items you want to
show up in your drop-down list. For example, if you want the drop down
to show dates ranging from last week to today:
A1:=TODAY()-7
A2:=TODAY()-6
..
..
A8:=TODAY()

2) Select the cell where you want the drop-down. From the menu, select
Data > Validation; Allow: List; Source: Select the range containing
the dates for the drop-down.

3) You can choose to display an input message or error message on the
other tabs

4) Once everything is working you can hide the columns containing the
list of dates to clean up the worksheet.

Hope this helps,
Dave