LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
carrera
 
Posts: n/a
Default Entering # to pick particular selection

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Making pick list conditional on selection from previous pick list Stewart Excel Discussion (Misc queries) 1 June 27th 05 11:30 AM
Fit Selection Setting Doesn't Hold Brett Excel Discussion (Misc queries) 1 April 20th 05 10:22 PM
Calculate Value of Cell From Pick List Choice Buz Excel Discussion (Misc queries) 1 April 5th 05 08:52 PM
SELECTION() Thrava Excel Discussion (Misc queries) 2 January 2nd 05 01:33 AM
limit cell list selection based on the selection of another list lorraine Excel Worksheet Functions 2 December 14th 04 08:17 PM


All times are GMT +1. The time now is 12:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"