Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation with additional input
Is it possible to have a single cell referenced to a separte cell that
contains additional data/information? I am trying to create an expense report. I would like to have expense amounts entered into the appropriate cells then when any cell is active, have a dedicated cell which will collect additional data (ie. how it was paid, explanation, city, etc.). Basically, when you click on any cell, there will be another cell with all the additional information to view. Ultimately, I would like to have an employee enter in a value, have a drop down list to enter whether it was company paid or personally paid, and then change the color of the value depending on the response. Then be able to separate all the data between company and personal. Can anyone inform me of the programming necessary to do this? Or if it is even possible to do in Excel? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation input message | Excel Discussion (Misc queries) | |||
DATA VALIDATION INPUT MESSAGE | Excel Discussion (Misc queries) | |||
Data Input Validation | Excel Discussion (Misc queries) | |||
Data Validation Input Message | Excel Worksheet Functions | |||
DataValidationInput message | Excel Worksheet Functions |