Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 - change cells depending on answer from drop-down menu
Hi,
I am developing a room booking spreadsheet. It is in effect a calendar. 1. Users would select from a drop-down menu the date they wish to book. 2. Users would select the amount of hours they wish to book from a second drop- down list. 3. They would also have to enter their name in another cell. I would like these answers to be reflected in the calendar. ie. if they choose 12/05/08 at 10am to 1pm and the name John Smith, I would like that block of time to be highlighted in the calendar with the name John Smith centred in the middle. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking choices in drop down menu to have automatic answer... | Excel Discussion (Misc queries) | |||
how do i export information from an answer from a drop down menu? | Excel Worksheet Functions | |||
Excel 2003 - Certain icons in drop down menu are not functioning | Excel Discussion (Misc queries) | |||
Drop down menu and two dimensional lookup in Excel 2003 | Excel Worksheet Functions | |||
How to get excel cells to change colors depending on value | Excel Worksheet Functions |