Mirror Wildcard?

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

Per Jessen

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
 

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

Similar Threads

use cell text in lookup function 3
How to write a function for column A = product of two columns, B a 4
Deletion Of Cells 1
How do I use advance filter correctly? 2
How do I use countif like sumif ie (range,criteria,count_range) 1
How to determine the values? 6
Complex decisions, maybe? 7
Combining SUMIF and SUBTOTAL 4

Top