Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm tracking the reasons given as to why overtime is being worked.
In the sheet I'm sending to the managers to fill out weekly, I'm providing a list at the top of common reasons, i.e. vacation coverage, short staffed, drawing labs, etc. The choices will be labeled 1 through ? ....and will be listed in cells C1 Through C? I'd like for them to be able to enter a number in a cell, and have the explanation associated with that # to appear either in that cell (preferable) or in the cell next to it. For example, they type "2" in F12 and "vacation" appears either in F12 or G12 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
Fit Selection Setting Doesn't Hold | Excel Discussion (Misc queries) | |||
Calculate Value of Cell From Pick List Choice | Excel Discussion (Misc queries) | |||
SELECTION() | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |