Extracting Every 19 Records in Excel to Create Random Sample
Hi,
I'd like to take my spreadsheet and extract every 19 records starting with record 1069 to create a random sample. Should I create a macro or function to tell Excel to select every 19 records?
Thanks so much for your quick reply. The code does select the correct first record 1069 but it only selects 135 households. I need a sample size of 192.
Also, I have to run a simple coding on 8 more spreadsheets, so I need to be able to insert the macro. I can insert a Marco. I just need to be able to see the code in a separate worksheet.
Simply run a Macro to copy every 19th row
Open in new window