Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change cell text based on another selected cell?
Hi: Thanks for considering my question. I have a row of 4 cells that I use as headings for the data below them. I also have elsewhere on the page 3 cells in a row-each with different text in each cell. What I would like to do is: When I select one of the 3 (selector) cells, I'd like to: 1)copy the contents of the selector cell (sel n) to another (pre selected prior to choosing sel x) cell, 2) change the contents of the row of 4 cells to some predetermined text strings. There could be up to 12 different selectors which means up to 12 different headings)....example is below: sel 1 sel 2 sel 3 sel 4 heading1 heading2 heading 3 heading 4 copied sel Any suggestions on how to do this is appreciated...Thank You! -John -- jjh ------------------------------------------------------------------------ jjh's Profile: http://www.excelforum.com/member.php...o&userid=36089 View this thread: http://www.excelforum.com/showthread...hreadid=558715 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change cell text based on another selected cell?
not clear what you want to do, sorry, but it sounds like you will need lookup tables to return desired text and a macro to initiate it -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=558715 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create formula that will pull a value based on text in diff cell? | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Splitting 1 cell into 2 based on underscore in text | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
How to auto-fill text based on text in another cell | Excel Discussion (Misc queries) |