MACRO RUN random percentage and copy of column values

Dear all, thanks in advance for looking at this thread..

I have found the following macro that randomly select an amount of cells based on a popup window that ask you how many cells you need to randomly get and copy the values into another column. So basically given a Column A with a series of numbers (there might be even empty cells in the middle), you run the macro and you are requested to provide the number of cells you want to be copied, the macro make some calculation and work on Columns B and C and copy the values randomly in Column D.

Said that.. my question is.. would it be possible to replace the number you request to have a copy with a percentage request? (e.g. instead of copy 15 numbers out 100, copy the 10% or 20% or whichever% out of 100) bear always in mind that within all the column A there might be some empty cells too which of course needs to be NOT calculated by the percentage..

Please Login or Register  to view this content.

Moderator Note:

Pls use code tags around your code as per forum rules.

Thanks Moderator for your support, was my first "copy code" thanks again hoping to get an answer soon.

Cheers

Mod Note:

I am also hoping to find your solution soon.Thanks for undrstanding! Good luck.

Thanks for sharing your solution with us!

Now you have to do something more according the forum rules.

Please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.