fill random cells in an area

  • Thread starter Thread starter hulub
  • Start date Start date
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:
 
i forgot something: range A1:A20 is in a new sheet not in the same shee
with the values. Sorry
 

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

Random Numbers 6
Random Number Cell Filling 9
fill random cells 1
generating random numbers without repeats 3
Copy data from unlocked cells 3
Basic Cell / Formula Copy Using a Step 2
Random number macro 10
Windows 10 One of my previous builds is experiencing random, multiple BSODs 9

Back
Top