Is there a formular or macro I can use that will look at my spreadsheet of 600 records ( a record for example being everything in A1 to Q1) and randomly pick 300 of them and then either move them to another sheet or colour the cells or something so...
Is there a formular or macro I can use that will look at my spreadsheet of 600 records ( a record for example being everything in A1 to Q1) and randomly pick 300 of them and then either move them to another sheet or colour the cells or something so I know which ones it has randomly selected.
Linear Mode
