Excel's got a data validation feature that I think will do what you need it to. Basically, you'll put all the 'data' for the dropdown box in a column (you can hide this afterwards) and then enable data validation for all your input cells so that they look-up from your data column.
What version of Excel are you using? I'm still figuring out 2007. Once I have the exact how-to I'll post it here.
-----Added 26/8/2008 at 10 : 30 : 30-----
Quote:
|
Originally Posted by MS Excel Help
To create a list of valid entries for the drop-down list, type the entries in a single column or row without blank cells. For example: A
1 Sales
2 Finance
3 R&D
4 MIS
Note You may want to sort the data in the order that you want it to appear in the drop-down list.
Select the cell where you want the drop-down list.
On the Data tab, in the Data Tools group, click Data Validation.
The Data Validation dialog box is displayed.
Click the Settings tab.
In the Allow box, click List.
To specify the location of the list of valid entries, do one of the following:
If the list is in the current worksheet, enter a reference to your list in the Source box.
Make sure that the In-cell drop-down check box is selected.
To specify whether the cell can be left blank, select or clear the Ignore blank check box.
|
That's basically it. I edited the Help a bit because they always give you more info than you need. Then, to get your total for the week, just do a SUM for all your input fields and display it wherever you want.