cashchris2005
New Member
- Joined
- Feb 23, 2011
- Messages
- 27
Hello All,
I have a question.... I am trying to make a spreadsheet that will allow me to have a combo box/or data validation list box, and based on the selection out of the combo box/list box, excel will automatically fill in other cells using information from another spreadsheet. Is this possible?
Example
Combo box in A1 asks if user wants standard process or new process. User selects standard process (on spreadsheet #1)
I now want cell A2 To automatically say 1 PSI, cell A3 to say 100C, and cell A4 to say 5 meters
This information will be located on spreadsheet #2 in the same work book.
Is this possible, or am I asking to much of excel?
I have a question.... I am trying to make a spreadsheet that will allow me to have a combo box/or data validation list box, and based on the selection out of the combo box/list box, excel will automatically fill in other cells using information from another spreadsheet. Is this possible?
Example
Combo box in A1 asks if user wants standard process or new process. User selects standard process (on spreadsheet #1)
I now want cell A2 To automatically say 1 PSI, cell A3 to say 100C, and cell A4 to say 5 meters
This information will be located on spreadsheet #2 in the same work book.
Is this possible, or am I asking to much of excel?
