|The following instructions are for Excel 2003. The same feature exists in 2007, but I don't know the exact steps. I'm sure you'll figure it out. If not, come on back and someone who has 2007 will detail the steps.|
1 - Enter the Doctor's names in a range of cells somewhere on your spreadsheet. I'll use G1:G7, but it really doesn't matter.
2 - Select the range of cells where they would reluctantly type in their names.
3 - With that range selected, click on Data...Validation...Allow...List.
4 - In the Source box enter the range that contains the Doctor's names as follows.
5 - Click OK.
This will put a Drop Down in each of the selected cells from which the Doc's can then select their own name.
If you want to get fancy, you could include a WorkSheet change macro to automatically insert the date for these lazy physicians.
Let's say the Drop Downs are in Column J (Column 10). The code below will automatically put the date in Column D of the same row when a name is selected.
Right click the sheet tab for the sheet you are using and paste this code into the window that opens. You can adjust the column designations to fit your needs.
Make sure you try these sugestions in a backup copy of your spreadsheet in case things go horribly wrong.
Private Sub Worksheet_Change(ByVal Target As Range)
'Was change made to Column J (10)?
If Target.Column = 10 Then
'If yes, put today's date in Column D of the same row.
Range("D" & Target.Row) = Date