Hello,
I am new to VBA and am learning as I go for a work project.
I need to cycle through groups of data (anywhere from 1-319 lines long in a file with 155,000+ lines of data) and perform some operations on them.
I am looking for recommendations on how to create a loop (looking at For/Each/Next loops right now) that will look at the information in column A (data-acq. session ID) to define each session as a "group" of data, so that the actions thereafter are only performed on that group, and not on the entire sheet. An example of the data is screenshot-ed below.
Thanks in advance for any advice!
[TABLE="width: 500"]
<tbody>[TR]
[TD]Session ID[/TD]
[TD]VTM Index[/TD]
[TD]Parameter Name[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]PD143148
[/TD]
[TD]0[/TD]
[TD]Position[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]1[/TD]
[TD]Speed[/TD]
[TD]34[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]2[/TD]
[TD]Odometer[/TD]
[TD]9110[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]3[/TD]
[TD]Position[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]4[/TD]
[TD]Odometer[/TD]
[TD]9156[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]5[/TD]
[TD]Speed[/TD]
[TD]56[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]6[/TD]
[TD]Speed[/TD]
[TD]72[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]7[/TD]
[TD]Position[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]8[/TD]
[TD]Odometer[/TD]
[TD]9234[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]9[/TD]
[TD]Position[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][TABLE="width: 167"]
<tbody>[TR]
[TD="class: xl65, width: 167"]PD129834[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]0[/TD]
[TD]Odometer[/TD]
[TD]324[/TD]
[/TR]
[TR]
[TD][TABLE="width: 167"]
<tbody>[TR]
[TD="class: xl65, width: 167"]PD129834[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1[/TD]
[TD]Odometer[/TD]
[TD]329[/TD]
[/TR]
[TR]
[TD][TABLE="width: 167"]
<tbody>[TR]
[TD="class: xl65, width: 167"]PD129834[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]2[/TD]
[TD]Position[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][TABLE="width: 167"]
<tbody>[TR]
[TD="class: xl65, width: 167"]PD129834[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]3[/TD]
[TD]Speed[/TD]
[TD]100[/TD]
[/TR]
</tbody>[/TABLE]
I am new to VBA and am learning as I go for a work project.
I need to cycle through groups of data (anywhere from 1-319 lines long in a file with 155,000+ lines of data) and perform some operations on them.
I am looking for recommendations on how to create a loop (looking at For/Each/Next loops right now) that will look at the information in column A (data-acq. session ID) to define each session as a "group" of data, so that the actions thereafter are only performed on that group, and not on the entire sheet. An example of the data is screenshot-ed below.
Thanks in advance for any advice!
[TABLE="width: 500"]
<tbody>[TR]
[TD]Session ID[/TD]
[TD]VTM Index[/TD]
[TD]Parameter Name[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]PD143148
[/TD]
[TD]0[/TD]
[TD]Position[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]1[/TD]
[TD]Speed[/TD]
[TD]34[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]2[/TD]
[TD]Odometer[/TD]
[TD]9110[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]3[/TD]
[TD]Position[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]4[/TD]
[TD]Odometer[/TD]
[TD]9156[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]5[/TD]
[TD]Speed[/TD]
[TD]56[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]6[/TD]
[TD]Speed[/TD]
[TD]72[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]7[/TD]
[TD]Position[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]8[/TD]
[TD]Odometer[/TD]
[TD]9234[/TD]
[/TR]
[TR]
[TD]PD143148[/TD]
[TD]9[/TD]
[TD]Position[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][TABLE="width: 167"]
<tbody>[TR]
[TD="class: xl65, width: 167"]PD129834[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]0[/TD]
[TD]Odometer[/TD]
[TD]324[/TD]
[/TR]
[TR]
[TD][TABLE="width: 167"]
<tbody>[TR]
[TD="class: xl65, width: 167"]PD129834[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1[/TD]
[TD]Odometer[/TD]
[TD]329[/TD]
[/TR]
[TR]
[TD][TABLE="width: 167"]
<tbody>[TR]
[TD="class: xl65, width: 167"]PD129834[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]2[/TD]
[TD]Position[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][TABLE="width: 167"]
<tbody>[TR]
[TD="class: xl65, width: 167"]PD129834[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]3[/TD]
[TD]Speed[/TD]
[TD]100[/TD]
[/TR]
</tbody>[/TABLE]