Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro/Formula Help?
A1 is any word A2 is blank A3 = A1 A4:A10 = random words C3:J3 = Reference words $C4-10:$J4-10=Random words What I need is when I type in a word from A4:A10 into the Cell A1, the cell A3 becomes that cell and it makes cells C3:J3 the corresponding values of the same row as the A4:A10 value For example IF I type Reference into A1, I need it to look like this Reference Test No HA DING (etc) Reference Test No HA DING (etc) Blank Moop Red Interesting Juggling Nine Ten Can anyone help me? -- fluci ------------------------------------------------------------------------ fluci's Profile: http://www.excelforum.com/member.php...o&userid=25896 View this thread: http://www.excelforum.com/showthread...hreadid=393190 |