fill random cells in an area

H

hulub

hi!
I have this problem: in one sheet a have 4 values (in the columns ABCD
row1) and I want to use this 4 values to fill randomly 4 of those 20
cells of the range A1:A20.
How to do this?
Thank you!:confused:
 
H

hulub

i forgot something: range A1:A20 is in a new sheet not in the same shee
with the values. Sorry
 
Top