| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Statement? Update text in one cell based on another
I need to have one cell populate with specific text based on the choice of
the user. Example: User can select from three choices in Column F (rows 39,40,41). I would like another cell in the workbook to display that choice. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If Statement? Update text in one cell based on another
In the other cell, place a Data Validation pull-down that references F39 thru
F41 -- Gary''s Student - gsnu200907 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If Statement? Update text in one cell based on another
I need the other cell to automatically populate with the user's choice. That
data is used in some auto calculations else where in the workbook. I'm not seeing that ability using validation. Am i missing it? "Gary''s Student" wrote: In the other cell, place a Data Validation pull-down that references F39 thru F41 -- Gary''s Student - gsnu200907 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If Statement? Update text in one cell based on another
Let's say the reference cell is Z100 and the choices are F39, F40, and F41.
I allow the user to make a choise by use data validation in Z100 to pick one of the three choices. In your application, how is the user chosing?? -- Gary''s Student - gsnu200907 "Kesbutler" wrote: I need the other cell to automatically populate with the user's choice. That data is used in some auto calculations else where in the workbook. I'm not seeing that ability using validation. Am i missing it? "Gary''s Student" wrote: In the other cell, place a Data Validation pull-down that references F39 thru F41 -- Gary''s Student - gsnu200907 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If Statement? Update text in one cell based on another
Because of the way the sheet is set up to collect much data they just put an
"x" in the cell for their selection. I could change the layout and use data validation. "Gary''s Student" wrote: Let's say the reference cell is Z100 and the choices are F39, F40, and F41. I allow the user to make a choise by use data validation in Z100 to pick one of the three choices. In your application, how is the user chosing?? -- Gary''s Student - gsnu200907 "Kesbutler" wrote: I need the other cell to automatically populate with the user's choice. That data is used in some auto calculations else where in the workbook. I'm not seeing that ability using validation. Am i missing it? "Gary''s Student" wrote: In the other cell, place a Data Validation pull-down that references F39 thru F41 -- Gary''s Student - gsnu200907 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select text in cell based on text from another cell, paste the text at the begining of a thrid cell, etc... | Excel Programming | |||
| How do I update links based on a cell value? | Excel Discussion (Misc queries) | |||
| update cell in other worksheet based... | Excel Worksheet Functions | |||
| Update Columns based on External Text file | Excel Programming | |||
| Deleting Rows based on text in cell & formatting cell based on text in column beside it | Excel Programming | |||
Linear Mode
