Forum Discussion
Help with a macro
Hi - I am trying to create a macro to do the following: Scan column for a number, if that number is 100, then copy and paste that row 50 times in the 2nd sheet. Then, it changes if the numb...
thank you very much!! that worked great!
Any chance you can help me randomly mix the rows I created. I think I can run a random number generator. Is that just =RAND?
Any chance you can help me randomly mix the rows I created. I think I can run a random number generator. Is that just =RAND?
Yes - you could add the formula =RAND() in an empty column, then sort on that column.