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!
<tbody>
</tbody>
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!
Session ID | VTM Index | Parameter Name | Value | |
PD143148 | 0 | Position | 0 | |
PD143148 | 1 | Speed | 34 | |
PD143148 | 2 | Odometer | 9110 | |
PD143148 | 3 | Position | 1 | |
PD143148 | 4 | Odometer | 9156 | |
PD143148 | 5 | Speed | 56 | |
PD143148 | 6 | Speed | 72 | |
PD143148 | 7 | Position | 0 | |
PD143148 | 8 | Odometer | 9234 | |
PD143148 | 9 | Position | 1 | |
<tbody> </tbody> | 0 | Odometer | 324 | |
<tbody> </tbody> | 1 | Odometer | 329 | |
<tbody> </tbody> | 2 | Position | 1 | |
<tbody> </tbody> | 3 | Speed | 100 |
<tbody>
</tbody>