Importing/coping data from one spreadsheet into another but

May 6, 2013 at 08:27:03
Specs: Windows 7
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.

See More: Importing/coping data from one spreadsheet into another but

Report •

May 6, 2013 at 09:58:15
If you pulled the 1st 15 entries for each state would that be sufficient? It wouldn't skew the resulting data in any way if it was always the first 15 entries, would it?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

May 6, 2013 at 10:07:25
You are correct. I just need the darn thing to bring over the 1st 15 of each state. If there are not 15 listed then it can not give me an error code. Sometimes the smaller states do not have as many lines as 15.

Report •

May 6, 2013 at 10:11:38
and if posible a final workpage that compiles all tabs (except 1st one) into a printable report. Row equals tab name (state) followed by 15 lines (or less) then the next state/tab. So when I am done I can print the summary page only. Oh darn perhaps I do not even need the tabs for each state purhaps just the summary page because truelly thats all I will need. I do this all manually but would like to run a Macro or similar but I am not able to figure out how to do this myself. UGH!

Report •

Related Solutions

Ask Question