How to change cell text based on another selected cell?

  • Thread starter Thread starter jjh
  • Start date Start date
J

jjh

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top