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:

Sub A_01Insert1AboveRow_Do1Time()
'This Macro will execute all of the Insert Row ABOVE
InsertRowDC01
InsertRowDC02
InsertRowDC03
InsertRowDC04
InsertRowDC05
InsertRowDC06
InsertRowDC07
InsertRowDC08
InsertRowDC09
InsertRowDC10
InsertRowDC11
InsertRowDC12
InsertRowDC13
InsertRowDC14
InsertRowDC15
InsertRowDC16
InsertRowDC17
InsertRowDC18
InsertRowDC19
InsertRowDC20
InsertRowDC21
InsertRowDC22
InsertRowDC23
End Sub
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