Hi tim201110 and Phuocam
Thanks for your inputs. Both solutions where not the answer that I was looking for. As seen in the sheet above I need the columns A and G to be filled with random numbers, but numbers that will stay inside the range defined in row 3-8. In the sheet you can see row 11 where data in column A is 1 and in column G is 85. That should have been column A=1 (a number between 1-5) and column B=a number between 5-12. So forth all the way through 10000 rows - but with random numbers defined from row 3-8. Do I make myself understandable?
Bookmarks