Extract data to multiple worksheets/books based on Column Value

[Anzer_ke]

Hi, I'm something of a script kiddy and my attempts to find a macro that fits my needs have failed.

The files look like this:

[TABLE="width: 1408"]
<tbody>[TR]
[TD="width: 64"]Time[/TD]
[TD="width: 64"]T2R[/TD]
[TD="width: 64"]T2L[/TD]
[TD="width: 64"]T3R[/TD]
[TD="width: 64"]T3L[/TD]
[TD="width: 64"]A1R[/TD]
[TD="width: 64"]A1L[/TD]
[TD="width: 64"]A2R[/TD]
[TD="width: 64"]A2L[/TD]
[TD="width: 64"]A3R[/TD]
[TD="width: 64"]A3L[/TD]
[TD="width: 64"]A4R[/TD]
[TD="width: 64"]A4L[/TD]
[TD="width: 64"]A5R[/TD]
[TD="width: 64"]A5L[/TD]
[TD="width: 64"]A6R[/TD]
[TD="width: 64"]A6L[/TD]
[TD="width: 64"]A7R[/TD]
[TD="width: 64"]A7L[/TD]
[TD="width: 64"]A8R[/TD]
[TD="width: 64"]A8L[/TD]
[TD="width: 64"]TrackName[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]0.090924[/TD]
[TD="align: right"]0.123839[/TD]
[TD="align: right"]0.151038[/TD]
[TD="align: right"]0.150756[/TD]
[TD="align: right"]0.178118[/TD]
[TD="align: right"]0.178547[/TD]
[TD="align: right"]0.205324[/TD]
[TD="align: right"]0.216712[/TD]
[TD="align: right"]0.223721[/TD]
[TD="align: right"]0.257117[/TD]
[TD="align: right"]0.25941[/TD]
[TD="align: right"]0.226461[/TD]
[TD="align: right"]0.318388[/TD]
[TD="align: right"]0.261929[/TD]
[TD="align: right"]0.309183[/TD]
[TD="align: right"]0.366577[/TD]
[TD="align: right"]0.25772[/TD]
[TD="align: right"]0.291869[/TD]
[TD="align: right"]0.158394[/TD]
[TD="align: right"]0.12345[/TD]
[TD]p[/TD]
[/TR]
[TR]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.067486[/TD]
[TD="align: right"]0.096805[/TD]
[TD="align: right"]0.139145[/TD]
[TD="align: right"]0.122591[/TD]
[TD="align: right"]0.15435[/TD]
[TD="align: right"]0.134305[/TD]
[TD="align: right"]0.175838[/TD]
[TD="align: right"]0.16767[/TD]
[TD="align: right"]0.190453[/TD]
[TD="align: right"]0.225337[/TD]
[TD="align: right"]0.213936[/TD]
[TD="align: right"]0.186507[/TD]
[TD="align: right"]0.2608[/TD]
[TD="align: right"]0.217103[/TD]
[TD="align: right"]0.257989[/TD]
[TD="align: right"]0.329131[/TD]
[TD="align: right"]0.302762[/TD]
[TD="align: right"]0.292193[/TD]
[TD="align: right"]0.173279[/TD]
[TD="align: right"]0.141501[/TD]
[TD]p[/TD]
[/TR]
[TR]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.062525[/TD]
[TD="align: right"]0.070561[/TD]
[TD="align: right"]0.120879[/TD]
[TD="align: right"]0.097968[/TD]
[TD="align: right"]0.143202[/TD]
[TD="align: right"]0.119893[/TD]
[TD="align: right"]0.150851[/TD]
[TD="align: right"]0.142618[/TD]
[TD="align: right"]0.165171[/TD]
[TD="align: right"]0.181165[/TD]
[TD="align: right"]0.182129[/TD]
[TD="align: right"]0.149184[/TD]
[TD="align: right"]0.226056[/TD]
[TD="align: right"]0.183769[/TD]
[TD="align: right"]0.214367[/TD]
[TD="align: right"]0.275224[/TD]
[TD="align: right"]0.269077[/TD]
[TD="align: right"]0.284095[/TD]
[TD="align: right"]0.172211[/TD]
[TD="align: right"]0.136847[/TD]
[TD]p[/TD]
[/TR]
[TR]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.07751[/TD]
[TD="align: right"]0.055893[/TD]
[TD="align: right"]0.138236[/TD]
[TD="align: right"]0.074305[/TD]
[TD="align: right"]0.149475[/TD]
[TD="align: right"]0.092797[/TD]
[TD="align: right"]0.142262[/TD]
[TD="align: right"]0.113404[/TD]
[TD="align: right"]0.147218[/TD]
[TD="align: right"]0.153459[/TD]
[TD="align: right"]0.16371[/TD]
[TD="align: right"]0.126134[/TD]
[TD="align: right"]0.184842[/TD]
[TD="align: right"]0.152593[/TD]
[TD="align: right"]0.175587[/TD]
[TD="align: right"]0.228591[/TD]
[TD="align: right"]0.230476[/TD]
[TD="align: right"]0.241943[/TD]
[TD="align: right"]0.150618[/TD]
[TD="align: right"]0.124349[/TD]
[TD]p[/TD]
[/TR]
[TR]
[TD="align: right"]0.8[/TD]
[TD="align: right"]0.109674[/TD]
[TD="align: right"]0.058506[/TD]
[TD="align: right"]0.175293[/TD]
[TD="align: right"]0.077767[/TD]
[TD="align: right"]0.178336[/TD]
[TD="align: right"]0.08741[/TD]
[TD="align: right"]0.169353[/TD]
[TD="align: right"]0.122791[/TD]
[TD="align: right"]0.153006[/TD]
[TD="align: right"]0.147446[/TD]
[TD="align: right"]0.140879[/TD]
[TD="align: right"]0.109745[/TD]
[TD="align: right"]0.18049[/TD]
[TD="align: right"]0.124904[/TD]
[TD="align: right"]0.151185[/TD]
[TD="align: right"]0.195672[/TD]
[TD="align: right"]0.177895[/TD]
[TD="align: right"]0.190695[/TD]
[TD="align: right"]0.135247[/TD]
[TD="align: right"]0.099613[/TD]
[TD]p[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]0.672306[/TD]
[TD="align: right"]0.706944[/TD]
[TD="align: right"]0.748782[/TD]
[TD="align: right"]0.665014[/TD]
[TD="align: right"]0.724259[/TD]
[TD="align: right"]0.651651[/TD]
[TD="align: right"]0.650378[/TD]
[TD="align: right"]0.646102[/TD]
[TD="align: right"]0.618494[/TD]
[TD="align: right"]0.62172[/TD]
[TD="align: right"]0.585196[/TD]
[TD="align: right"]0.529146[/TD]
[TD="align: right"]0.576621[/TD]
[TD="align: right"]0.529624[/TD]
[TD="align: right"]0.519548[/TD]
[TD="align: right"]0.587789[/TD]
[TD="align: right"]0.564807[/TD]
[TD="align: right"]0.591167[/TD]
[TD="align: right"]0.762729[/TD]
[TD="align: right"]0.715483[/TD]
[TD]p[/TD]
[/TR]
[TR]
[TD="align: right"]1.2[/TD]
[TD="align: right"]0.172474[/TD]
[TD="align: right"]0.078745[/TD]
[TD="align: right"]0.29141[/TD]
[TD="align: right"]0.070021[/TD]
[TD="align: right"]0.273052[/TD]
[TD="align: right"]0.096794[/TD]
[TD="align: right"]0.25017[/TD]
[TD="align: right"]0.126699[/TD]
[TD="align: right"]0.19686[/TD]
[TD="align: right"]0.13037[/TD]
[TD="align: right"]0.159294[/TD]
[TD="align: right"]0.066924[/TD]
[TD="align: right"]0.161558[/TD]
[TD="align: right"]0.084613[/TD]
[TD="align: right"]0.106214[/TD]
[TD="align: right"]0.120056[/TD]
[TD="align: right"]0.121246[/TD]
[TD="align: right"]0.103519[/TD]
[TD="align: right"]0.102416[/TD]
[TD="align: right"]0.041954[/TD]
[TD]p[/TD]
[/TR]
[TR]
[TD="align: right"]1.4[/TD]
[TD="align: right"]0.216902[/TD]
[TD="align: right"]0.07131[/TD]
[TD="align: right"]0.350609[/TD]
[TD="align: right"]0.072791[/TD]
[TD="align: right"]0.319896[/TD]
[TD="align: right"]0.07994[/TD]
[TD="align: right"]0.280976[/TD]
[TD="align: right"]0.121483[/TD]
[TD="align: right"]0.212934[/TD]
[TD="align: right"]0.108087[/TD]
[TD="align: right"]0.156692[/TD]
[TD="align: right"]0.051117[/TD]
[TD="align: right"]0.156248[/TD]
[TD="align: right"]0.051551[/TD]
[TD="align: right"]0.076282[/TD]
[TD="align: right"]0.092587[/TD]
[TD="align: right"]0.069731[/TD]
[TD="align: right"]0.050775[/TD]
[TD="align: right"]0.077721[/TD]
[TD="align: right"]0.014561[/TD]
[TD]right turn[/TD]
[/TR]
[TR]
[TD="align: right"]1.6[/TD]
[TD="align: right"]0.254596[/TD]
[TD="align: right"]0.093165[/TD]
[TD="align: right"]0.410966[/TD]
[TD="align: right"]0.076955[/TD]
[TD="align: right"]0.354453[/TD]
[TD="align: right"]0.084433[/TD]
[TD="align: right"]0.318903[/TD]
[TD="align: right"]0.127538[/TD]
[TD="align: right"]0.239741[/TD]
[TD="align: right"]0.091007[/TD]
[TD="align: right"]0.165614[/TD]
[TD="align: right"]0.039899[/TD]
[TD="align: right"]0.155916[/TD]
[TD="align: right"]0.039695[/TD]
[TD="align: right"]0.061716[/TD]
[TD="align: right"]0.071879[/TD]
[TD="align: right"]0.038358[/TD]
[TD="align: right"]0.019979[/TD]
[TD="align: right"]0.055968[/TD]
[TD="align: right"]-0.01739[/TD]
[TD]TB[/TD]
[/TR]
[TR]
[TD="align: right"]1.8[/TD]
[TD="align: right"]0.240433[/TD]
[TD="align: right"]0.085955[/TD]
[TD="align: right"]0.425152[/TD]
[TD="align: right"]0.059535[/TD]
[TD="align: right"]0.360318[/TD]
[TD="align: right"]0.068018[/TD]
[TD="align: right"]0.341963[/TD]
[TD="align: right"]0.119606[/TD]
[TD="align: right"]0.287933[/TD]
[TD="align: right"]0.128773[/TD]
[TD="align: right"]0.216263[/TD]
[TD="align: right"]0.05756[/TD]
[TD="align: right"]0.178617[/TD]
[TD="align: right"]0.039676[/TD]
[TD="align: right"]0.066158[/TD]
[TD="align: right"]0.064124[/TD]
[TD="align: right"]0.020834[/TD]
[TD="align: right"]-0.00128[/TD]
[TD="align: right"]0.033785[/TD]
[TD="align: right"]-0.03775[/TD]
[TD]TB[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]0.227386[/TD]
[TD="align: right"]0.066297[/TD]
[TD="align: right"]0.396166[/TD]
[TD="align: right"]0.031321[/TD]
[TD="align: right"]0.335793[/TD]
[TD="align: right"]0.050881[/TD]
[TD="align: right"]0.323931[/TD]
[TD="align: right"]0.113415[/TD]
[TD="align: right"]0.296301[/TD]
[TD="align: right"]0.17851[/TD]
[TD="align: right"]0.27745[/TD]
[TD="align: right"]0.122477[/TD]
[TD="align: right"]0.243569[/TD]
[TD="align: right"]0.103446[/TD]
[TD="align: right"]0.08174[/TD]
[TD="align: right"]0.088319[/TD]
[TD="align: right"]0.017908[/TD]
[TD="align: right"]-0.00978[/TD]
[TD="align: right"]0.036473[/TD]
[TD="align: right"]-0.0299[/TD]
[TD]TB[/TD]
[/TR]
[TR]
[TD="align: right"]2.2[/TD]
[TD="align: right"]0.183819[/TD]
[TD="align: right"]0.046684[/TD]
[TD="align: right"]0.364566[/TD]
[TD="align: right"]0.015399[/TD]
[TD="align: right"]0.299248[/TD]
[TD="align: right"]0.033832[/TD]
[TD="align: right"]0.282808[/TD]
[TD="align: right"]0.099432[/TD]
[TD="align: right"]0.270901[/TD]
[TD="align: right"]0.152662[/TD]
[TD="align: right"]0.274167[/TD]
[TD="align: right"]0.147237[/TD]
[TD="align: right"]0.301625[/TD]
[TD="align: right"]0.167436[/TD]
[TD="align: right"]0.152507[/TD]
[TD="align: right"]0.160959[/TD]
[TD="align: right"]0.049863[/TD]
[TD="align: right"]0.024751[/TD]
[TD="align: right"]0.036133[/TD]
[TD="align: right"]-0.02581[/TD]
[TD]TB[/TD]
[/TR]
[TR]
[TD="align: right"]2.4[/TD]
[TD="align: right"]0.148302[/TD]
[TD="align: right"]0.027892[/TD]
[TD="align: right"]0.326335[/TD]
[TD="align: right"]0.004001[/TD]
[TD="align: right"]0.271028[/TD]
[TD="align: right"]0.028152[/TD]
[TD="align: right"]0.250121[/TD]
[TD="align: right"]0.083351[/TD]
[TD="align: right"]0.23139[/TD]
[TD="align: right"]0.136192[/TD]
[TD="align: right"]0.2422[/TD]
[TD="align: right"]0.120988[/TD]
[TD="align: right"]0.292992[/TD]
[TD="align: right"]0.18164[/TD]
[TD="align: right"]0.206333[/TD]
[TD="align: right"]0.228929[/TD]
[TD="align: right"]0.117744[/TD]
[TD="align: right"]0.097926[/TD]
[TD="align: right"]0.05382[/TD]
[TD="align: right"]0.000703[/TD]
[TD]TB[/TD]
[/TR]
[TR]
[TD="align: right"]2.6[/TD]
[TD="align: right"]0.110797[/TD]
[TD="align: right"]0.023959[/TD]
[TD="align: right"]0.28736[/TD]
[TD="align: right"]-0.00272[/TD]
[TD="align: right"]0.232669[/TD]
[TD="align: right"]0.01093[/TD]
[TD="align: right"]0.222252[/TD]
[TD="align: right"]0.05522[/TD]
[TD="align: right"]0.201628[/TD]
[TD="align: right"]0.108286[/TD]
[TD="align: right"]0.211411[/TD]
[TD="align: right"]0.106546[/TD]
[TD="align: right"]0.258353[/TD]
[TD="align: right"]0.154662[/TD]
[TD="align: right"]0.229013[/TD]
[TD="align: right"]0.26328[/TD]
[TD="align: right"]0.18534[/TD]
[TD="align: right"]0.169168[/TD]
[TD="align: right"]0.095097[/TD]
[TD="align: right"]0.052153[/TD]
[TD]p[/TD]
[/TR]
[TR]
[TD="align: right"]2.8[/TD]
[TD="align: right"]0.099264[/TD]
[TD="align: right"]0.028422[/TD]
[TD="align: right"]0.255029[/TD]
[TD="align: right"]-0.00669[/TD]
[TD="align: right"]0.210645[/TD]
[TD="align: right"]0.003953[/TD]
[TD="align: right"]0.201595[/TD]
[TD="align: right"]0.0515[/TD]
[TD="align: right"]0.195596[/TD]
[TD="align: right"]0.100692[/TD]
[TD="align: right"]0.190067[/TD]
[TD="align: right"]0.076828[/TD]
[TD="align: right"]0.228446[/TD]
[TD="align: right"]0.135547[/TD]
[TD="align: right"]0.210985[/TD]
[TD="align: right"]0.252558[/TD]
[TD="align: right"]0.226976[/TD]
[TD="align: right"]0.219891[/TD]
[TD="align: right"]0.137307[/TD]
[TD="align: right"]0.089219[/TD]
[TD]p[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]0.071213[/TD]
[TD="align: right"]0.019751[/TD]
[TD="align: right"]0.227323[/TD]
[TD="align: right"]-0.02343[/TD]
[TD="align: right"]0.191725[/TD]
[TD="align: right"]0.01842[/TD]
[TD="align: right"]0.182162[/TD]
[TD="align: right"]0.036542[/TD]
[TD="align: right"]0.162775[/TD]
[TD="align: right"]0.081739[/TD]
[TD="align: right"]0.1595[/TD]
[TD="align: right"]0.079074[/TD]
[TD="align: right"]0.201206[/TD]
[TD="align: right"]0.101815[/TD]
[TD="align: right"]0.195205[/TD]
[TD="align: right"]0.216822[/TD]
[TD="align: right"]0.211662[/TD]
[TD="align: right"]0.224134[/TD]
[TD="align: right"]0.135775[/TD]
[TD="align: right"]0.106554[/TD]
[TD]p[/TD]
[/TR]
[TR]
[TD="align: right"]3.2[/TD]
[TD="align: right"]0.064361[/TD]
[TD="align: right"]0.014324[/TD]
[TD="align: right"]0.212866[/TD]
[TD="align: right"]-0.01288[/TD]
[TD="align: right"]0.179912[/TD]
[TD="align: right"]0.021263[/TD]
[TD="align: right"]0.152768[/TD]
[TD="align: right"]0.033323[/TD]
[TD="align: right"]0.149319[/TD]
[TD="align: right"]0.074638[/TD]
[TD="align: right"]0.147328[/TD]
[TD="align: right"]0.063313[/TD]
[TD="align: right"]0.167621[/TD]
[TD="align: right"]0.096551[/TD]
[TD="align: right"]0.163981[/TD]
[TD="align: right"]0.190907[/TD]
[TD="align: right"]0.182661[/TD]
[TD="align: right"]0.197451[/TD]
[TD="align: right"]0.135196[/TD]
[TD="align: right"]0.103357[/TD]
[TD]p[/TD]
[/TR]
[TR]
[TD="align: right"]3.4[/TD]
[TD="align: right"]0.079435[/TD]
[TD="align: right"]0.036145[/TD]
[TD="align: right"]0.199246[/TD]
[TD="align: right"]0.013001[/TD]
[TD="align: right"]0.180701[/TD]
[TD="align: right"]0.03921[/TD]
[TD="align: right"]0.148356[/TD]
[TD="align: right"]0.054732[/TD]
[TD="align: right"]0.133733[/TD]
[TD="align: right"]0.076212[/TD]
[TD="align: right"]0.122617[/TD]
[TD="align: right"]0.054074[/TD]
[TD="align: right"]0.140881[/TD]
[TD="align: right"]0.081178[/TD]
[TD="align: right"]0.118904[/TD]
[TD="align: right"]0.161323[/TD]
[TD="align: right"]0.148622[/TD]
[TD="align: right"]0.156922[/TD]
[TD="align: right"]0.118427[/TD]
[TD="align: right"]0.076915[/TD]
[TD]p[/TD]
[/TR]
[TR]
[TD="align: right"]3.6[/TD]
[TD="align: right"]0.091826[/TD]
[TD="align: right"]0.089774[/TD]
[TD="align: right"]0.219235[/TD]
[TD="align: right"]0.068517[/TD]
[TD="align: right"]0.190657[/TD]
[TD="align: right"]0.075212[/TD]
[TD="align: right"]0.159602[/TD]
[TD="align: right"]0.097242[/TD]
[TD="align: right"]0.130308[/TD]
[TD="align: right"]0.091112[/TD]
[TD="align: right"]0.095676[/TD]
[TD="align: right"]0.050656[/TD]
[TD="align: right"]0.127665[/TD]
[TD="align: right"]0.074106[/TD]
[TD="align: right"]0.093882[/TD]
[TD="align: right"]0.13303[/TD]
[TD="align: right"]0.104617[/TD]
[TD="align: right"]0.12496[/TD]
[TD="align: right"]0.094431[/TD]
[TD="align: right"]0.060119[/TD]
[TD]p[/TD]
[/TR]
[TR]
[TD="align: right"]3.8[/TD]
[TD="align: right"]0.113236[/TD]
[TD="align: right"]0.1218[/TD]
[TD="align: right"]0.210623[/TD]
[TD="align: right"]0.122096[/TD]
[TD="align: right"]0.174953[/TD]
[TD="align: right"]0.133605[/TD]
[TD="align: right"]0.15013[/TD]
[TD="align: right"]0.140904[/TD]
[TD="align: right"]0.117402[/TD]
[TD="align: right"]0.124441[/TD]
[TD="align: right"]0.079041[/TD]
[TD="align: right"]0.065875[/TD]
[TD="align: right"]0.10165[/TD]
[TD="align: right"]0.067134[/TD]
[TD="align: right"]0.064993[/TD]
[TD="align: right"]0.108434[/TD]
[TD="align: right"]0.07369[/TD]
[TD="align: right"]0.090662[/TD]
[TD="align: right"]0.077235[/TD]
[TD="align: right"]0.033351[/TD]
[TD]left turn[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]0.122359[/TD]
[TD="align: right"]0.181113[/TD]
[TD="align: right"]0.197178[/TD]
[TD="align: right"]0.180545[/TD]
[TD="align: right"]0.165376[/TD]
[TD="align: right"]0.168625[/TD]
[TD="align: right"]0.134865[/TD]
[TD="align: right"]0.183534[/TD]
[TD="align: right"]0.097764[/TD]
[TD="align: right"]0.154288[/TD]
[TD="align: right"]0.061258[/TD]
[TD="align: right"]0.089651[/TD]
[TD="align: right"]0.076329[/TD]
[TD="align: right"]0.069816[/TD]
[TD="align: right"]0.047961[/TD]
[TD="align: right"]0.099075[/TD]
[TD="align: right"]0.035438[/TD]
[TD="align: right"]0.060017[/TD]
[TD="align: right"]0.055939[/TD]
[TD="align: right"]0.019039[/TD]
[TD]left turn[/TD]
[/TR]
[TR]
[TD="align: right"]4.2[/TD]
[TD="align: right"]0.157709[/TD]
[TD="align: right"]0.223413[/TD]
[TD="align: right"]0.209386[/TD]
[TD="align: right"]0.231728[/TD]
[TD="align: right"]0.153052[/TD]
[TD="align: right"]0.215731[/TD]
[TD="align: right"]0.12914[/TD]
[TD="align: right"]0.215824[/TD]
[TD="align: right"]0.082069[/TD]
[TD="align: right"]0.182515[/TD]
[TD="align: right"]0.051482[/TD]
[TD="align: right"]0.088879[/TD]
[TD="align: right"]0.06475[/TD]
[TD="align: right"]0.057892[/TD]
[TD="align: right"]0.01409[/TD]
[TD="align: right"]0.082486[/TD]
[TD="align: right"]0.00643[/TD]
[TD="align: right"]0.025113[/TD]
[TD="align: right"]0.031239[/TD]
[TD="align: right"]-0.01256[/TD]
[TD]left turn[/TD]
[/TR]
[TR]
[TD="align: right"]4.4[/TD]
[TD="align: right"]0.166721[/TD]
[TD="align: right"]0.261007[/TD]
[TD="align: right"]0.20748[/TD]
[TD="align: right"]0.302113[/TD]
[TD="align: right"]0.14146[/TD]
[TD="align: right"]0.262628[/TD]
[TD="align: right"]0.122768[/TD]
[TD="align: right"]0.273696[/TD]
[TD="align: right"]0.062981[/TD]
[TD="align: right"]0.2119[/TD]
[TD="align: right"]0.03616[/TD]
[TD="align: right"]0.106158[/TD]
[TD="align: right"]0.0407[/TD]
[TD="align: right"]0.053773[/TD]
[TD="align: right"]-0.0083[/TD]
[TD="align: right"]0.06526[/TD]
[TD="align: right"]-0.01927[/TD]
[TD="align: right"]0.000133[/TD]
[TD="align: right"]0.025646[/TD]
[TD="align: right"]-0.03279[/TD]
[TD]left turn[/TD]
[/TR]
[TR]
[TD="align: right"]4.6[/TD]
[TD="align: right"]0.183047[/TD]
[TD="align: right"]0.293442[/TD]
[TD="align: right"]0.199177[/TD]
[TD="align: right"]0.336323[/TD]
[TD="align: right"]0.129905[/TD]
[TD="align: right"]0.29298[/TD]
[TD="align: right"]0.114937[/TD]
[TD="align: right"]0.295616[/TD]
[TD="align: right"]0.055061[/TD]
[TD="align: right"]0.232636[/TD]
[TD="align: right"]0.018107[/TD]
[TD="align: right"]0.107896[/TD]
[TD="align: right"]0.033048[/TD]
[TD="align: right"]0.045569[/TD]
[TD="align: right"]-0.02326[/TD]
[TD="align: right"]0.047701[/TD]
[TD="align: right"]-0.04928[/TD]
[TD="align: right"]-0.02457[/TD]
[TD="align: right"]0.019616[/TD]
[TD="align: right"]-0.04695[/TD]
[TD]TB[/TD]
[/TR]
[TR]
[TD="align: right"]4.8[/TD]
[TD="align: right"]0.164267[/TD]
[TD="align: right"]0.283444[/TD]
[TD="align: right"]0.178466[/TD]
[TD="align: right"]0.350132[/TD]
[TD="align: right"]0.132721[/TD]
[TD="align: right"]0.30002[/TD]
[TD="align: right"]0.128947[/TD]
[TD="align: right"]0.318504[/TD]
[TD="align: right"]0.085657[/TD]
[TD="align: right"]0.269686[/TD]
[TD="align: right"]0.046559[/TD]
[TD="align: right"]0.128478[/TD]
[TD="align: right"]0.045707[/TD]
[TD="align: right"]0.056857[/TD]
[TD="align: right"]-0.03066[/TD]
[TD="align: right"]0.038699[/TD]
[TD="align: right"]-0.05635[/TD]
[TD="align: right"]-0.04157[/TD]
[TD="align: right"]-0.00216[/TD]
[TD="align: right"]-0.04739[/TD]
[TD]TB[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]0.114712[/TD]
[TD="align: right"]0.237296[/TD]
[TD="align: right"]0.148309[/TD]
[TD="align: right"]0.306958[/TD]
[TD="align: right"]0.120084[/TD]
[TD="align: right"]0.281882[/TD]
[TD="align: right"]0.151586[/TD]
[TD="align: right"]0.302698[/TD]
[TD="align: right"]0.146301[/TD]
[TD="align: right"]0.302998[/TD]
[TD="align: right"]0.117905[/TD]
[TD="align: right"]0.176982[/TD]
[TD="align: right"]0.093924[/TD]
[TD="align: right"]0.091124[/TD]
[TD="align: right"]-0.01287[/TD]
[TD="align: right"]0.063889[/TD]
[TD="align: right"]-0.05574[/TD]
[TD="align: right"]-0.0512[/TD]
[TD="align: right"]-0.00138[/TD]
[TD="align: right"]-0.0647[/TD]
[TD]TB[/TD]
[/TR]
[TR]
[TD="align: right"]5.2[/TD]
[TD="align: right"]0.087319[/TD]
[TD="align: right"]0.19775[/TD]
[TD="align: right"]0.10984[/TD]
[TD="align: right"]0.263834[/TD]
[TD="align: right"]0.080774[/TD]
[TD="align: right"]0.244145[/TD]
[TD="align: right"]0.124288[/TD]
[TD="align: right"]0.275437[/TD]
[TD="align: right"]0.165935[/TD]
[TD="align: right"]0.285204[/TD]
[TD="align: right"]0.167607[/TD]
[TD="align: right"]0.20604[/TD]
[TD="align: right"]0.186898[/TD]
[TD="align: right"]0.146492[/TD]
[TD="align: right"]0.036837[/TD]
[TD="align: right"]0.117452[/TD]
[TD="align: right"]-0.04796[/TD]
[TD="align: right"]-0.03768[/TD]
[TD="align: right"]0.003126[/TD]
[TD="align: right"]-0.06285[/TD]
[TD]TB[/TD]
[/TR]
[TR]
[TD="align: right"]5.4[/TD]
[TD="align: right"]0.067618[/TD]
[TD="align: right"]0.15215[/TD]
[TD="align: right"]0.0866[/TD]
[TD="align: right"]0.228884[/TD]
[TD="align: right"]0.080694[/TD]
[TD="align: right"]0.200072[/TD]
[TD="align: right"]0.103514[/TD]
[TD="align: right"]0.228122[/TD]
[TD="align: right"]0.136211[/TD]
[TD="align: right"]0.254932[/TD]
[TD="align: right"]0.173951[/TD]
[TD="align: right"]0.191154[/TD]
[TD="align: right"]0.236668[/TD]
[TD="align: right"]0.189316[/TD]
[TD="align: right"]0.122561[/TD]
[TD="align: right"]0.192155[/TD]
[TD="align: right"]0.011395[/TD]
[TD="align: right"]0.010875[/TD]
[TD="align: right"]0.026924[/TD]
[TD="align: right"]-0.04172[/TD]
[TD]TB[/TD]
[/TR]
[TR]
[TD="align: right"]5.6[/TD]
[TD="align: right"]0.05873[/TD]
[TD="align: right"]0.139375[/TD]
[TD="align: right"]0.064475[/TD]
[TD="align: right"]0.19291[/TD]
[TD="align: right"]0.067792[/TD]
[TD="align: right"]0.186444[/TD]
[TD="align: right"]0.087226[/TD]
[TD="align: right"]0.195731[/TD]
[TD="align: right"]0.111938[/TD]
[TD="align: right"]0.231495[/TD]
[TD="align: right"]0.135839[/TD]
[TD="align: right"]0.170029[/TD]
[TD="align: right"]0.21851[/TD]
[TD="align: right"]0.174841[/TD]
[TD="align: right"]0.180693[/TD]
[TD="align: right"]0.251747[/TD]
[TD="align: right"]0.109437[/TD]
[TD="align: right"]0.101875[/TD]
[TD="align: right"]0.05494[/TD]
[TD="align: right"]-0.00504[/TD]
[TD]TB[/TD]
[/TR]
</tbody>[/TABLE]

Though a lot larger (~50,000 - ~100,000 rows)

I need to go through them and split off sequences of the same TrackName into separate files (worksheet or workbook, it doesn't matter which) with the same header row. So the first 7 rows, then the 8th row, then the next 5 and so on. The trick is that it needs to keep the sequences separate, rather than just grouping all the "p"s together, all the "TB"s together and so on. I've found a couple macros that will split it according to the TrackName column, but nothing that can split it into each sequence of rows with the same TrackName.

Ideally I also need the macro to delete the Time and TrackName columns from the created worksheets/books and save them as Tab-delimited txt files, but that step is at least somewhat possible to do manually, whereas splitting the files into each sequence manually would take an infeasibly long time.

The macro from http://www.mrexcel.com/forum/excel-questions/396069-copy-new-worksheets.html is the closest I've gotten so far, but it gives me this kind of output:

[TABLE="width: 1408"]
<tbody>[TR]
[TD="width: 64"]Time[/TD]
[TD="width: 64"]T2R[/TD]
[TD="width: 64"]T2L[/TD]
[TD="width: 64"]T3R[/TD]
[TD="width: 64"]T3L[/TD]
[TD="width: 64"]A1R[/TD]
[TD="width: 64"]A1L[/TD]
[TD="width: 64"]A2R[/TD]
[TD="width: 64"]A2L[/TD]
[TD="width: 64"]A3R[/TD]
[TD="width: 64"]A3L[/TD]
[TD="width: 64"]A4R[/TD]
[TD="width: 64"]A4L[/TD]
[TD="width: 64"]A5R[/TD]
[TD="width: 64"]A5L[/TD]
[TD="width: 64"]A6R[/TD]
[TD="width: 64"]A6L[/TD]
[TD="width: 64"]A7R[/TD]
[TD="width: 64"]A7L[/TD]
[TD="width: 64"]A8R[/TD]
[TD="width: 64"]A8L[/TD]
[TD="width: 64"]TrackName[/TD]
[/TR]
[TR]
[TD="align: right"]10.6[/TD]
[TD="align: right"]0.217975[/TD]
[TD="align: right"]0.055962[/TD]
[TD="align: right"]0.279961[/TD]
[TD="align: right"]0.08888[/TD]
[TD="align: right"]0.247724[/TD]
[TD="align: right"]0.095954[/TD]
[TD="align: right"]0.234625[/TD]
[TD="align: right"]0.107772[/TD]
[TD="align: right"]0.162886[/TD]
[TD="align: right"]0.088578[/TD]
[TD="align: right"]0.108038[/TD]
[TD="align: right"]0.014682[/TD]
[TD="align: right"]0.128019[/TD]
[TD="align: right"]0.001972[/TD]
[TD="align: right"]0.020367[/TD]
[TD="align: right"]0.045757[/TD]
[TD="align: right"]-0.00496[/TD]
[TD="align: right"]-0.01554[/TD]
[TD="align: right"]0.041308[/TD]
[TD="align: right"]-0.03127[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]10.8[/TD]
[TD="align: right"]0.198445[/TD]
[TD="align: right"]0.040474[/TD]
[TD="align: right"]0.26478[/TD]
[TD="align: right"]0.0549[/TD]
[TD="align: right"]0.236733[/TD]
[TD="align: right"]0.075198[/TD]
[TD="align: right"]0.253562[/TD]
[TD="align: right"]0.1349[/TD]
[TD="align: right"]0.216836[/TD]
[TD="align: right"]0.155899[/TD]
[TD="align: right"]0.162583[/TD]
[TD="align: right"]0.069643[/TD]
[TD="align: right"]0.140112[/TD]
[TD="align: right"]0.029576[/TD]
[TD="align: right"]0.022752[/TD]
[TD="align: right"]0.030432[/TD]
[TD="align: right"]-0.01633[/TD]
[TD="align: right"]-0.0351[/TD]
[TD="align: right"]0.037202[/TD]
[TD="align: right"]-0.05016[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]0.162707[/TD]
[TD="align: right"]0.035617[/TD]
[TD="align: right"]0.235147[/TD]
[TD="align: right"]0.031678[/TD]
[TD="align: right"]0.207756[/TD]
[TD="align: right"]0.054839[/TD]
[TD="align: right"]0.226958[/TD]
[TD="align: right"]0.126638[/TD]
[TD="align: right"]0.236282[/TD]
[TD="align: right"]0.180356[/TD]
[TD="align: right"]0.21922[/TD]
[TD="align: right"]0.128754[/TD]
[TD="align: right"]0.20083[/TD]
[TD="align: right"]0.086011[/TD]
[TD="align: right"]0.049752[/TD]
[TD="align: right"]0.063374[/TD]
[TD="align: right"]-0.02519[/TD]
[TD="align: right"]-0.04019[/TD]
[TD="align: right"]0.030119[/TD]
[TD="align: right"]-0.0544[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]11.2[/TD]
[TD="align: right"]0.132503[/TD]
[TD="align: right"]0.021913[/TD]
[TD="align: right"]0.208226[/TD]
[TD="align: right"]0.019308[/TD]
[TD="align: right"]0.185041[/TD]
[TD="align: right"]0.037295[/TD]
[TD="align: right"]0.198208[/TD]
[TD="align: right"]0.097239[/TD]
[TD="align: right"]0.196314[/TD]
[TD="align: right"]0.162[/TD]
[TD="align: right"]0.229407[/TD]
[TD="align: right"]0.152661[/TD]
[TD="align: right"]0.25941[/TD]
[TD="align: right"]0.125067[/TD]
[TD="align: right"]0.113606[/TD]
[TD="align: right"]0.132106[/TD]
[TD="align: right"]0.008907[/TD]
[TD="align: right"]-0.00734[/TD]
[TD="align: right"]0.022419[/TD]
[TD="align: right"]-0.03618[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]11.4[/TD]
[TD="align: right"]0.093744[/TD]
[TD="align: right"]0.006747[/TD]
[TD="align: right"]0.187288[/TD]
[TD="align: right"]0.017655[/TD]
[TD="align: right"]0.15786[/TD]
[TD="align: right"]0.032248[/TD]
[TD="align: right"]0.172779[/TD]
[TD="align: right"]0.07481[/TD]
[TD="align: right"]0.177793[/TD]
[TD="align: right"]0.130525[/TD]
[TD="align: right"]0.197489[/TD]
[TD="align: right"]0.126468[/TD]
[TD="align: right"]0.259421[/TD]
[TD="align: right"]0.150861[/TD]
[TD="align: right"]0.168932[/TD]
[TD="align: right"]0.203376[/TD]
[TD="align: right"]0.078344[/TD]
[TD="align: right"]0.062885[/TD]
[TD="align: right"]0.055963[/TD]
[TD="align: right"]-0.01486[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]11.6[/TD]
[TD="align: right"]0.071035[/TD]
[TD="align: right"]-0.00082[/TD]
[TD="align: right"]0.155297[/TD]
[TD="align: right"]-0.00403[/TD]
[TD="align: right"]0.146532[/TD]
[TD="align: right"]0.020282[/TD]
[TD="align: right"]0.149547[/TD]
[TD="align: right"]0.065712[/TD]
[TD="align: right"]0.154113[/TD]
[TD="align: right"]0.123093[/TD]
[TD="align: right"]0.183244[/TD]
[TD="align: right"]0.111447[/TD]
[TD="align: right"]0.236977[/TD]
[TD="align: right"]0.134686[/TD]
[TD="align: right"]0.193921[/TD]
[TD="align: right"]0.231111[/TD]
[TD="align: right"]0.153154[/TD]
[TD="align: right"]0.146984[/TD]
[TD="align: right"]0.082798[/TD]
[TD="align: right"]0.035427[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]11.8[/TD]
[TD="align: right"]0.056772[/TD]
[TD="align: right"]-0.01022[/TD]
[TD="align: right"]0.133204[/TD]
[TD="align: right"]-0.01072[/TD]
[TD="align: right"]0.130242[/TD]
[TD="align: right"]0.011792[/TD]
[TD="align: right"]0.132473[/TD]
[TD="align: right"]0.047595[/TD]
[TD="align: right"]0.141099[/TD]
[TD="align: right"]0.104186[/TD]
[TD="align: right"]0.162006[/TD]
[TD="align: right"]0.098141[/TD]
[TD="align: right"]0.208011[/TD]
[TD="align: right"]0.113122[/TD]
[TD="align: right"]0.180511[/TD]
[TD="align: right"]0.215915[/TD]
[TD="align: right"]0.197482[/TD]
[TD="align: right"]0.202722[/TD]
[TD="align: right"]0.124058[/TD]
[TD="align: right"]0.07239[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD="align: right"]0.055788[/TD]
[TD="align: right"]-0.00454[/TD]
[TD="align: right"]0.130163[/TD]
[TD="align: right"]-0.01325[/TD]
[TD="align: right"]0.121275[/TD]
[TD="align: right"]0.017523[/TD]
[TD="align: right"]0.125497[/TD]
[TD="align: right"]0.044143[/TD]
[TD="align: right"]0.119379[/TD]
[TD="align: right"]0.086676[/TD]
[TD="align: right"]0.137689[/TD]
[TD="align: right"]0.084208[/TD]
[TD="align: right"]0.172907[/TD]
[TD="align: right"]0.093723[/TD]
[TD="align: right"]0.155621[/TD]
[TD="align: right"]0.196943[/TD]
[TD="align: right"]0.200698[/TD]
[TD="align: right"]0.202493[/TD]
[TD="align: right"]0.124982[/TD]
[TD="align: right"]0.09462[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]12.2[/TD]
[TD="align: right"]0.053227[/TD]
[TD="align: right"]-0.01377[/TD]
[TD="align: right"]0.123428[/TD]
[TD="align: right"]-0.01087[/TD]
[TD="align: right"]0.128814[/TD]
[TD="align: right"]0.013719[/TD]
[TD="align: right"]0.117726[/TD]
[TD="align: right"]0.033672[/TD]
[TD="align: right"]0.112206[/TD]
[TD="align: right"]0.082978[/TD]
[TD="align: right"]0.118196[/TD]
[TD="align: right"]0.064204[/TD]
[TD="align: right"]0.161561[/TD]
[TD="align: right"]0.080869[/TD]
[TD="align: right"]0.129938[/TD]
[TD="align: right"]0.160393[/TD]
[TD="align: right"]0.182497[/TD]
[TD="align: right"]0.174934[/TD]
[TD="align: right"]0.122718[/TD]
[TD="align: right"]0.08431[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]12.4[/TD]
[TD="align: right"]0.089812[/TD]
[TD="align: right"]0.000112[/TD]
[TD="align: right"]0.156157[/TD]
[TD="align: right"]-0.00663[/TD]
[TD="align: right"]0.147416[/TD]
[TD="align: right"]0.02262[/TD]
[TD="align: right"]0.123173[/TD]
[TD="align: right"]0.033184[/TD]
[TD="align: right"]0.102866[/TD]
[TD="align: right"]0.067991[/TD]
[TD="align: right"]0.09472[/TD]
[TD="align: right"]0.058683[/TD]
[TD="align: right"]0.132638[/TD]
[TD="align: right"]0.06646[/TD]
[TD="align: right"]0.10345[/TD]
[TD="align: right"]0.140968[/TD]
[TD="align: right"]0.134052[/TD]
[TD="align: right"]0.145379[/TD]
[TD="align: right"]0.107775[/TD]
[TD="align: right"]0.059909[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]12.6
[/TD]
[TD="align: right"]0.120187[/TD]
[TD="align: right"]0.020802[/TD]
[TD="align: right"]0.186923[/TD]
[TD="align: right"]0.007217[/TD]
[TD="align: right"]0.181433[/TD]
[TD="align: right"]0.042765[/TD]
[TD="align: right"]0.135126[/TD]
[TD="align: right"]0.04677[/TD]
[TD="align: right"]0.106446[/TD]
[TD="align: right"]0.055101[/TD]
[TD="align: right"]0.099266[/TD]
[TD="align: right"]0.043743[/TD]
[TD="align: right"]0.115183[/TD]
[TD="align: right"]0.04464[/TD]
[TD="align: right"]0.08465[/TD]
[TD="align: right"]0.114301[/TD]
[TD="align: right"]0.104881[/TD]
[TD="align: right"]0.103725[/TD]
[TD="align: right"]0.094998[/TD]
[TD="align: right"]0.051358[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]15
[/TD]
[TD="align: right"]0.119803[/TD]
[TD="align: right"]0.048772[/TD]
[TD="align: right"]0.322071[/TD]
[TD="align: right"]0.005317[/TD]
[TD="align: right"]0.290721[/TD]
[TD="align: right"]0.016964[/TD]
[TD="align: right"]0.215367[/TD]
[TD="align: right"]0.025892[/TD]
[TD="align: right"]0.141896[/TD]
[TD="align: right"]0.014525[/TD]
[TD="align: right"]0.080998[/TD]
[TD="align: right"]-0.02084[/TD]
[TD="align: right"]0.043994[/TD]
[TD="align: right"]-0.04685[/TD]
[TD="align: right"]-0.05326[/TD]
[TD="align: right"]-0.04465[/TD]
[TD="align: right"]-0.09187[/TD]
[TD="align: right"]-0.09341[/TD]
[TD="align: right"]-0.02574[/TD]
[TD="align: right"]-0.08869[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]15.2[/TD]
[TD="align: right"]0.09874[/TD]
[TD="align: right"]0.031004[/TD]
[TD="align: right"]0.284842[/TD]
[TD="align: right"]0.006475[/TD]
[TD="align: right"]0.274684[/TD]
[TD="align: right"]0.026695[/TD]
[TD="align: right"]0.228255[/TD]
[TD="align: right"]0.061535[/TD]
[TD="align: right"]0.183927[/TD]
[TD="align: right"]0.056634[/TD]
[TD="align: right"]0.09993[/TD]
[TD="align: right"]0.009586[/TD]
[TD="align: right"]0.054931[/TD]
[TD="align: right"]-0.03316[/TD]
[TD="align: right"]-0.05446[/TD]
[TD="align: right"]-0.05103[/TD]
[TD="align: right"]-0.09503[/TD]
[TD="align: right"]-0.11651[/TD]
[TD="align: right"]-0.03603[/TD]
[TD="align: right"]-0.08883[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]15.4[/TD]
[TD="align: right"]0.081421[/TD]
[TD="align: right"]0.011976[/TD]
[TD="align: right"]0.248103[/TD]
[TD="align: right"]-0.01542[/TD]
[TD="align: right"]0.23723[/TD]
[TD="align: right"]0.01028[/TD]
[TD="align: right"]0.207274[/TD]
[TD="align: right"]0.066002[/TD]
[TD="align: right"]0.196152[/TD]
[TD="align: right"]0.097158[/TD]
[TD="align: right"]0.158947[/TD]
[TD="align: right"]0.082142[/TD]
[TD="align: right"]0.111282[/TD]
[TD="align: right"]0.032079[/TD]
[TD="align: right"]-0.027[/TD]
[TD="align: right"]-0.01392[/TD]
[TD="align: right"]-0.09109[/TD]
[TD="align: right"]-0.12113[/TD]
[TD="align: right"]-0.04332[/TD]
[TD="align: right"]-0.10222[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]15.6[/TD]
[TD="align: right"]0.063779[/TD]
[TD="align: right"]0.006321[/TD]
[TD="align: right"]0.200885[/TD]
[TD="align: right"]-0.01682[/TD]
[TD="align: right"]0.183674[/TD]
[TD="align: right"]-0.00345[/TD]
[TD="align: right"]0.168069[/TD]
[TD="align: right"]0.044166[/TD]
[TD="align: right"]0.172365[/TD]
[TD="align: right"]0.088328[/TD]
[TD="align: right"]0.187047[/TD]
[TD="align: right"]0.117808[/TD]
[TD="align: right"]0.187305[/TD]
[TD="align: right"]0.107361[/TD]
[TD="align: right"]0.027478[/TD]
[TD="align: right"]0.058289[/TD]
[TD="align: right"]-0.07617[/TD]
[TD="align: right"]-0.08888[/TD]
[TD="align: right"]-0.03508[/TD]
[TD="align: right"]-0.0859[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]15.8[/TD]
[TD="align: right"]0.040494[/TD]
[TD="align: right"]0.00153[/TD]
[TD="align: right"]0.167639[/TD]
[TD="align: right"]-0.03606[/TD]
[TD="align: right"]0.152338[/TD]
[TD="align: right"]-0.01986[/TD]
[TD="align: right"]0.133461[/TD]
[TD="align: right"]0.020486[/TD]
[TD="align: right"]0.142642[/TD]
[TD="align: right"]0.046571[/TD]
[TD="align: right"]0.17429[/TD]
[TD="align: right"]0.111764[/TD]
[TD="align: right"]0.210491[/TD]
[TD="align: right"]0.151705[/TD]
[TD="align: right"]0.11297[/TD]
[TD="align: right"]0.160595[/TD]
[TD="align: right"]-0.01898[/TD]
[TD="align: right"]-0.02582[/TD]
[TD="align: right"]-0.01324[/TD]
[TD="align: right"]-0.06371[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD="align: right"]0.031055[/TD]
[TD="align: right"]-0.00924[/TD]
[TD="align: right"]0.153814[/TD]
[TD="align: right"]-0.04768[/TD]
[TD="align: right"]0.144072[/TD]
[TD="align: right"]-0.04273[/TD]
[TD="align: right"]0.124742[/TD]
[TD="align: right"]-0.00543[/TD]
[TD="align: right"]0.122905[/TD]
[TD="align: right"]0.020651[/TD]
[TD="align: right"]0.150208[/TD]
[TD="align: right"]0.078973[/TD]
[TD="align: right"]0.199428[/TD]
[TD="align: right"]0.143222[/TD]
[TD="align: right"]0.152561[/TD]
[TD="align: right"]0.196948[/TD]
[TD="align: right"]0.070305[/TD]
[TD="align: right"]0.059468[/TD]
[TD="align: right"]0.024602[/TD]
[TD="align: right"]-0.0274[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]16.2[/TD]
[TD="align: right"]0.022942[/TD]
[TD="align: right"]-0.00442[/TD]
[TD="align: right"]0.136653[/TD]
[TD="align: right"]-0.05252[/TD]
[TD="align: right"]0.135352[/TD]
[TD="align: right"]-0.03899[/TD]
[TD="align: right"]0.116681[/TD]
[TD="align: right"]-0.01908[/TD]
[TD="align: right"]0.122297[/TD]
[TD="align: right"]0.005833[/TD]
[TD="align: right"]0.125237[/TD]
[TD="align: right"]0.044204[/TD]
[TD="align: right"]0.161597[/TD]
[TD="align: right"]0.116248[/TD]
[TD="align: right"]0.150356[/TD]
[TD="align: right"]0.200009[/TD]
[TD="align: right"]0.129959[/TD]
[TD="align: right"]0.121621[/TD]
[TD="align: right"]0.067365[/TD]
[TD="align: right"]0.02572[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]16.4[/TD]
[TD="align: right"]0.025125[/TD]
[TD="align: right"]0.019323[/TD]
[TD="align: right"]0.122356[/TD]
[TD="align: right"]-0.03428[/TD]
[TD="align: right"]0.13034[/TD]
[TD="align: right"]-0.02657[/TD]
[TD="align: right"]0.107256[/TD]
[TD="align: right"]-0.01691[/TD]
[TD="align: right"]0.113839[/TD]
[TD="align: right"]0.020372[/TD]
[TD="align: right"]0.106488[/TD]
[TD="align: right"]0.046205[/TD]
[TD="align: right"]0.14286[/TD]
[TD="align: right"]0.090035[/TD]
[TD="align: right"]0.129108[/TD]
[TD="align: right"]0.180102[/TD]
[TD="align: right"]0.1229[/TD]
[TD="align: right"]0.131331[/TD]
[TD="align: right"]0.077418[/TD]
[TD="align: right"]0.035033[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]16.6[/TD]
[TD="align: right"]0.039753[/TD]
[TD="align: right"]0.049378[/TD]
[TD="align: right"]0.110926[/TD]
[TD="align: right"]0.000715[/TD]
[TD="align: right"]0.117577[/TD]
[TD="align: right"]-0.00226[/TD]
[TD="align: right"]0.091529[/TD]
[TD="align: right"]0.014563[/TD]
[TD="align: right"]0.099996[/TD]
[TD="align: right"]0.026791[/TD]
[TD="align: right"]0.087503[/TD]
[TD="align: right"]0.040677[/TD]
[TD="align: right"]0.122476[/TD]
[TD="align: right"]0.062677[/TD]
[TD="align: right"]0.09944[/TD]
[TD="align: right"]0.151493[/TD]
[TD="align: right"]0.107805[/TD]
[TD="align: right"]0.106694[/TD]
[TD="align: right"]0.081133[/TD]
[TD="align: right"]0.024343[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]17.6[/TD]
[TD="align: right"]0.067585[/TD]
[TD="align: right"]0.243585[/TD]
[TD="align: right"]0.056828[/TD]
[TD="align: right"]0.253042[/TD]
[TD="align: right"]0.054246[/TD]
[TD="align: right"]0.212211[/TD]
[TD="align: right"]0.05205[/TD]
[TD="align: right"]0.185057[/TD]
[TD="align: right"]0.028429[/TD]
[TD="align: right"]0.13535[/TD]
[TD="align: right"]0.008384[/TD]
[TD="align: right"]0.077574[/TD]
[TD="align: right"]0.046345[/TD]
[TD="align: right"]0.038782[/TD]
[TD="align: right"]-0.00092[/TD]
[TD="align: right"]0.05451[/TD]
[TD="align: right"]-0.02459[/TD]
[TD="align: right"]-0.02295[/TD]
[TD="align: right"]0.012996[/TD]
[TD="align: right"]-0.04391[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]17.8[/TD]
[TD="align: right"]0.044668[/TD]
[TD="align: right"]0.237916[/TD]
[TD="align: right"]0.0475[/TD]
[TD="align: right"]0.278677[/TD]
[TD="align: right"]0.046056[/TD]
[TD="align: right"]0.223599[/TD]
[TD="align: right"]0.050267[/TD]
[TD="align: right"]0.232169[/TD]
[TD="align: right"]0.039224[/TD]
[TD="align: right"]0.159476[/TD]
[TD="align: right"]0.020279[/TD]
[TD="align: right"]0.091728[/TD]
[TD="align: right"]0.039909[/TD]
[TD="align: right"]0.034883[/TD]
[TD="align: right"]-0.01807[/TD]
[TD="align: right"]0.04297[/TD]
[TD="align: right"]-0.0482[/TD]
[TD="align: right"]-0.04984[/TD]
[TD="align: right"]0.0008[/TD]
[TD="align: right"]-0.04526[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD="align: right"]0.032984[/TD]
[TD="align: right"]0.213373[/TD]
[TD="align: right"]0.02797[/TD]
[TD="align: right"]0.269723[/TD]
[TD="align: right"]0.044066[/TD]
[TD="align: right"]0.231051[/TD]
[TD="align: right"]0.081191[/TD]
[TD="align: right"]0.247155[/TD]
[TD="align: right"]0.080994[/TD]
[TD="align: right"]0.197945[/TD]
[TD="align: right"]0.054046[/TD]
[TD="align: right"]0.133323[/TD]
[TD="align: right"]0.050634[/TD]
[TD="align: right"]0.058568[/TD]
[TD="align: right"]-0.02741[/TD]
[TD="align: right"]0.046677[/TD]
[TD="align: right"]-0.05261[/TD]
[TD="align: right"]-0.06616[/TD]
[TD="align: right"]0.001192[/TD]
[TD="align: right"]-0.05352[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]18.2[/TD]
[TD="align: right"]0.007896[/TD]
[TD="align: right"]0.185023[/TD]
[TD="align: right"]0.00541[/TD]
[TD="align: right"]0.250739[/TD]
[TD="align: right"]0.02389[/TD]
[TD="align: right"]0.210266[/TD]
[TD="align: right"]0.079767[/TD]
[TD="align: right"]0.225572[/TD]
[TD="align: right"]0.112679[/TD]
[TD="align: right"]0.222722[/TD]
[TD="align: right"]0.109574[/TD]
[TD="align: right"]0.1755[/TD]
[TD="align: right"]0.106952[/TD]
[TD="align: right"]0.099682[/TD]
[TD="align: right"]-0.00036[/TD]
[TD="align: right"]0.073685[/TD]
[TD="align: right"]-0.05957[/TD]
[TD="align: right"]-0.06809[/TD]
[TD="align: right"]-0.00406[/TD]
[TD="align: right"]-0.06262[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]18.4[/TD]
[TD="align: right"]0.000237[/TD]
[TD="align: right"]0.162273[/TD]
[TD="align: right"]-0.01673[/TD]
[TD="align: right"]0.212991[/TD]
[TD="align: right"]0.012393[/TD]
[TD="align: right"]0.173895[/TD]
[TD="align: right"]0.059131[/TD]
[TD="align: right"]0.193284[/TD]
[TD="align: right"]0.100834[/TD]
[TD="align: right"]0.206622[/TD]
[TD="align: right"]0.132641[/TD]
[TD="align: right"]0.183571[/TD]
[TD="align: right"]0.168022[/TD]
[TD="align: right"]0.142979[/TD]
[TD="align: right"]0.05568[/TD]
[TD="align: right"]0.13196[/TD]
[TD="align: right"]-0.03258[/TD]
[TD="align: right"]-0.04493[/TD]
[TD="align: right"]0.005786[/TD]
[TD="align: right"]-0.0565[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]18.6[/TD]
[TD="align: right"]-0.00188[/TD]
[TD="align: right"]0.132993[/TD]
[TD="align: right"]-0.02115[/TD]
[TD="align: right"]0.187822[/TD]
[TD="align: right"]0.009686[/TD]
[TD="align: right"]0.151429[/TD]
[TD="align: right"]0.045823[/TD]
[TD="align: right"]0.153259[/TD]
[TD="align: right"]0.077356[/TD]
[TD="align: right"]0.169117[/TD]
[TD="align: right"]0.118984[/TD]
[TD="align: right"]0.155367[/TD]
[TD="align: right"]0.18346[/TD]
[TD="align: right"]0.150773[/TD]
[TD="align: right"]0.114055[/TD]
[TD="align: right"]0.195944[/TD]
[TD="align: right"]0.022434[/TD]
[TD="align: right"]0.012183[/TD]
[TD="align: right"]0.017141[/TD]
[TD="align: right"]-0.03556[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]18.8[/TD]
[TD="align: right"]-0.00967[/TD]
[TD="align: right"]0.112522[/TD]
[TD="align: right"]-0.01967[/TD]
[TD="align: right"]0.151115[/TD]
[TD="align: right"]0.004619[/TD]
[TD="align: right"]0.129054[/TD]
[TD="align: right"]0.037045[/TD]
[TD="align: right"]0.134322[/TD]
[TD="align: right"]0.064901[/TD]
[TD="align: right"]0.143406[/TD]
[TD="align: right"]0.091418[/TD]
[TD="align: right"]0.13278[/TD]
[TD="align: right"]0.158616[/TD]
[TD="align: right"]0.135755[/TD]
[TD="align: right"]0.139194[/TD]
[TD="align: right"]0.224478[/TD]
[TD="align: right"]0.089173[/TD]
[TD="align: right"]0.087251[/TD]
[TD="align: right"]0.054629[/TD]
[TD="align: right"]-0.00538[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD="align: right"]-0.00328[/TD]
[TD="align: right"]0.080878[/TD]
[TD="align: right"]-0.02035[/TD]
[TD="align: right"]0.134095[/TD]
[TD="align: right"]0.010359[/TD]
[TD="align: right"]0.113745[/TD]
[TD="align: right"]0.033616[/TD]
[TD="align: right"]0.110655[/TD]
[TD="align: right"]0.060195[/TD]
[TD="align: right"]0.117216[/TD]
[TD="align: right"]0.071867[/TD]
[TD="align: right"]0.105224[/TD]
[TD="align: right"]0.139865[/TD]
[TD="align: right"]0.110711[/TD]
[TD="align: right"]0.126498[/TD]
[TD="align: right"]0.208275[/TD]
[TD="align: right"]0.115085[/TD]
[TD="align: right"]0.122725[/TD]
[TD="align: right"]0.071749[/TD]
[TD="align: right"]0.020974[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD="align: right"]19.2[/TD]
[TD="align: right"]0.003033[/TD]
[TD="align: right"]0.074836[/TD]
[TD="align: right"]-0.00538[/TD]
[TD="align: right"]0.108002[/TD]
[TD="align: right"]0.012305[/TD]
[TD="align: right"]0.096558[/TD]
[TD="align: right"]0.033521[/TD]
[TD="align: right"]0.098677[/TD]
[TD="align: right"]0.051998[/TD]
[TD="align: right"]0.099196[/TD]
[TD="align: right"]0.057145[/TD]
[TD="align: right"]0.071869[/TD]
[TD="align: right"]0.119139[/TD]
[TD="align: right"]0.08806[/TD]
[TD="align: right"]0.099615[/TD]
[TD="align: right"]0.174099[/TD]
[TD="align: right"]0.108273[/TD]
[TD="align: right"]0.109594[/TD]
[TD="align: right"]0.063348[/TD]
[TD="align: right"]0.021973[/TD]
[TD]b
[/TD]
[/TR]
</tbody>[/TABLE]

And for the full size files having to go through and manually separate the files wherever there's a break in the time sequence is still not feasible.

 

[Anzer_ke]

Figured it out.

If anyone else ever has the same problem, this is the code I cobbled together.

Public Sub SplitToFiles()

' MACRO SplitToFiles
' Last update: 2012-03-04
' Author: mtone
' Version 1.1
' Description:
' Loops through a specified column, and split each distinct values into a separate file by making a copy and deleting rows below and above
'
' Note: Values in the column should be unique or sorted.
'
' The following cells are ignored when delimiting sections:
' - blank cells, or containing spaces only
' - same value repeated
' - cells containing "total"
'
' Files are saved in a "Split" subfolder from the location of the source workbook, and named after the section name.

Dim osh As Worksheet ' Original sheet
Dim iRow As Long ' Cursors
Dim iCol As Long
Dim iFirstRow As Long ' Constant
Dim iTotalRows As Long ' Constant
Dim iStartRow As Long ' Section delimiters
Dim iStopRow As Long
Dim sSectionName As String ' Section name (and filename)
Dim sFileNames As String ' filename
Dim sFinalName As String ' filename
Dim rCell As Range ' current cell
Dim owb As Workbook ' Original workbook
Dim sFilePath As String ' Constant
Dim iCount As Integer ' # of documents created

iCol = Application.InputBox("Enter the column number used for splitting", "Select column", 2, , , , , 1)
iRow = Application.InputBox("Enter the starting row number (to skip header)", "Select row", 5, , , , , 1)
iFirstRow = iRow

Set osh = Application.ActiveSheet
Set owb = Application.ActiveWorkbook
iTotalRows = osh.UsedRange.Rows.Count
sFilePath = Application.ActiveWorkbook.Path

If Dir(sFilePath + "\Split", vbDirectory) = "" Then
MkDir sFilePath + "\Split"
End If

'Turn Off Screen Updating Events
Application.EnableEvents = False
Application.ScreenUpdating = False

Do
' Get cell at cursor
Set rCell = osh.Cells(iRow, iCol)
sCell = Replace(rCell.Text, " ", "")

If sCell = "" Or (rCell.Text = sSectionName And iStartRow <> 0) Or InStr(1, rCell.Text, "total", vbTextCompare) <> 0 Then
' Skip condition met
Else
' Found new section
If iStartRow = 0 Then
' StartRow delimiter not set, meaning beginning a new section
sSectionName = rCell.Text
iStartRow = iRow
Else
' StartRow delimiter set, meaning we reached the end of a section
iStopRow = iRow - 1

' file name as count
sFileNames = iCount

' Pass variables to a separate sub to create and save the new worksheet
CopySheet osh, iFirstRow, iStartRow, iStopRow, iTotalRows, sFilePath, sSectionName, sFileNames, sFinalName, owb.fileFormat
iCount = iCount + 1

' Reset section delimiters
iStartRow = 0
iStopRow = 0

' Ready to continue loop
iRow = iRow - 1
End If
End If

' Continue until last row is reached
If iRow < iTotalRows Then
iRow = iRow + 1
Else
' Finished. Save the last section
iStopRow = iRow
CopySheet osh, iFirstRow, iStartRow, iStopRow, iTotalRows, sFilePath, sSectionName, sFileNames, sFinalName, owb.fileFormat
iCount = iCount + 1

' Exit
Exit Do
End If
Loop

'Turn On Screen Updating Events
Application.ScreenUpdating = True
Application.EnableEvents = True

MsgBox Str(iCount) + " documents saved in " + sFilePath


End Sub

Public Sub DeleteRows(targetSheet As Worksheet, RowFrom As Long, RowTo As Long)

Dim rngRange As Range
Set rngRange = Range(targetSheet.Cells(RowFrom, 1), targetSheet.Cells(RowTo, 1)).EntireRow
rngRange.Select
rngRange.Delete

End Sub


Public Sub CopySheet(osh As Worksheet, iFirstRow As Long, iStartRow As Long, iStopRow As Long, iTotalRows As Long, sFilePath As String, sSectionName As String, sFileNames As String, sFinalName As String, fileFormat As XlFileFormat)
Dim ash As Worksheet ' Copied sheet
Dim awb As Workbook ' New workbook

' Copy book
osh.Copy
Set ash = Application.ActiveSheet

' Delete Rows after section
If iTotalRows > iStopRow Then
DeleteRows ash, iStopRow + 1, iTotalRows
End If

' Delete Rows before section
If iStartRow > iFirstRow Then
DeleteRows ash, iFirstRow, iStartRow - 1
End If

' Select left-topmost cell
ash.Cells(1, 1).Select

' Clean up a few characters to prevent invalid filename
sSectionName = Replace(sSectionName, "/", " ")
sSectionName = Replace(sSectionName, "\", " ")
sSectionName = Replace(sSectionName, ":", " ")
sSectionName = Replace(sSectionName, "=", " ")
sSectionName = Replace(sSectionName, "*", " ")
sSectionName = Replace(sSectionName, ".", " ")
sSectionName = Replace(sSectionName, "?", ".q.")

' Delete Columns
Columns([22]).EntireColumn.Delete
Columns([1]).EntireColumn.Delete

sFinalName = sSectionName & "_" & sFileNames

' Save in same format as original workbook, need to get it to save section name before file count
ash.SaveAs sFilePath + "\Split\" + sSectionName & "_" & sFileNames, xlTextWindows

' Close
Set awb = ash.Parent
awb.Close SaveChanges:=False
End Sub

Based on what I found here: Can I split a spreadsheet into multiple files based on a column in Excel 2007? - Super User