|I am trying to import rows with certain value into a new spreadsheet. Specifically, I have a report with mutiple states testing results on it. I need the report to assign random numbers to each sort by state then pull 15 of each and place them on their own spreadsheet based on state. Basically from the report I need results from each state randomly selected 15 total for each state and each state put on its own spreadsheet. I am working in Excel 2007. The report is same imported from what appears to me to be an Access type data base. But the doc. I am working with is excel so I guess that does not matter. |
It would be great to run a Macro and have it all go on its own if possible since I will be doing this often. I am intermediete so as much help as I can get (a sample or doc. to use etc.) would be greatly appreciated.
UPDATE! I just found out I do not nesc. need to pull a random sample if its difficult but only need 15 from each state to populate their own sheet. Ex. Workbook/Sheet 1 is a report, then Sheet/tab 2 is 15 rows from Sheet/tab 1 if column E=AK, Sheet/tab 3 is 15 rows if column E=OH on its own sheet etc.