Mirror Wildcard?

  • Thread starter Thread starter thecdnmole
  • Start date Start date
T

thecdnmole

I have empty cells, A1:A10, and in cells C1:C10 I have data. If A1 is
selected, I would like to be able to click on any cell in colum C and that
info then appears in A1. Then I will select A2, and again, click on any cell
in C1:C10 and that appears in A2 and so on. I do not want cells A1 etc. to
change once populated. This can be a macro as well. Thanks!
 
Hi

Maybe you could use a Validation list.

Select A1:A10 then goto Data > Validation > Allow: List > Source:
=$C$1:$C$10 > OK

Regards,
Per
 
Back
Top