Macro: Streamline Bulky Macros & Pars a Range of Rows to a New Sheet

[puppetpalace]

Hello! I have been lurking a bit on the forums and have used problem solving from other threads to put together a copy-pasted-Frankenstein macro (I have no prior experience with macros or programming). I am working with a giant excel sheet that contains “data collection points” that have an “On” and an “Off” (e.g.: DataCollection01On, DataCollection01Off, DataCollection02On, DataCollection02Off, etc). What I am attempting to do is pars the data to make it easier for analysis.

What I have created is 4 macros that activate a large number of other macros that do the same repetitive commands, but on different DataCollection# points.
Example:

Please Login or Register  to view this content.

What I have works, but is prone to freezing the Excel program. I was hoping I might be able to get some assistance to streamline what I have done and optimize the usability of my macros. I have attached an Excel file with untouched sample data with the macros included. (I attempted to paste my entire code using the tags, however it went beyond the character limits. Please see my attached file which should contain my code.)
---

Additionally, there are a number of things that I was not able to figure out how to do:

• have each data collection range copy and paste into its own separate sheet
• copy and paste row 1 (data headers) from sheet1 at the top of each newly pasted DataCollection# sheet in the excel file.
• insert 3 blank rows between the row 1 (data headers) and the pasted DataCollection#On row (I am told this is necessary to do quick average/min/max/std.dev. etc formulas at the bottom of certain columns)

If anyone had any tips on this, it would be greatly appreciated. I have also attached a file of how I would ideally like the setup of the excel sheets to appear in case my description was not adequate.

External links to attachment (my files were too large to upload):

http://dl.dropbox.com/u/19746131/Forum_TestData.xlsm - sample data worksheet with the macros
macro_codes.txt - just a text file with the macros if you want to see the full mess

http://dl.dropbox.com/u/19746131/For...orldExcel.xlsm- how my excel data would appear in an "ideal world" with the datacollection points pasting into their own sheet

[puppetpalace]

After more poking around, I think I may have found an answer to the second portion of my post.

Here is a sample of the code if anyone has any thoughts on how this could be streamlined:

Please Login or Register  to view this content.