Change a row of headings based on other selected cells
 

Hi:
Thanks for considering my question. I have a row of 4 cells that I us
as headings for the data below them. I also have elsewhere on the pag
3 cells in a row-each with different text in each cell. What I woul
like to do is:

When I select one of the 3 (selector) cells, I'd like to:
1)copy the contents of the selected cell (sel n) to another (pr
selected prior to choosing sel x) cell,
2) change the contents of the row of 4 cells to some predetermined tex
strings. There could be up to 12 different selectors which means up t
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!
-Joh

--
jj
-----------------------------------------------------------------------
jjh's Profile: http://www.excelforum.com/member.php...fo&userid=3608
View this thread: http://www.excelforum.com/showthread.php?threadid=55871