F
fluci
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
Can anyone help me?
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?