Hi everyone, I need help with making a Random Population VBA.
For now, I have made an example based on a formula:
=INDEX(Lists!A2:A612, RANDBETWEEN(2, 612))
What I am trying to do is to randomly populate data from the 'Lists" Sheets based on the range specified. I am trying to populate this data to a certain range: ActiveSheets("F5:F500")
Any help is much appreciated!
For now, I have made an example based on a formula:
=INDEX(Lists!A2:A612, RANDBETWEEN(2, 612))
What I am trying to do is to randomly populate data from the 'Lists" Sheets based on the range specified. I am trying to populate this data to a certain range: ActiveSheets("F5:F500")
Any help is much appreciated!