I have the below data set.
I'm trying to transfer a given block of data onto a userform based on finding the value (ticket #) in column A
In the case of ticket# 50503 there are a total of four line items that need to be captured (columns E, F & G) and listed in the respected text boxes on a userform.
The amount of rows varies by each ticket number. Some have two lines, some have 3, 7 8 etc.,
What can I use and how can I find the last row within any given block of data?
Once found, how can a loop be setup for this?
I'm trying to transfer a given block of data onto a userform based on finding the value (ticket #) in column A
In the case of ticket# 50503 there are a total of four line items that need to be captured (columns E, F & G) and listed in the respected text boxes on a userform.
The amount of rows varies by each ticket number. Some have two lines, some have 3, 7 8 etc.,
What can I use and how can I find the last row within any given block of data?
Once found, how can a loop be setup for this?
| Ticket # | Make | Model | Color | Part# | Qty | Service | Description | Tech | Expected Return | Returned to Shop | Invoice # | Complete or Partial |
50500 | Chevy | Camaro | White | 101 | 3 | AA3 | 3 LINE SVC | Brian | 3/26/2020 | 4/9/2020 | 65231 | |
| 105 | 1 | AA2 | 3 LINE SVC | |||||||||
| 1051.1 | 1 | AB4 | 3 LINE CLR | |||||||||
50501 | Chevy | Corvette | Cream | 101 | 3 | AB8 | 3 LINE SVC | Matt | 3/27/2020 | 4/9/2020 & 4/9/2020 | 15440 / 626 | |
| 105 | 1 | AA2 | 3 LINE SVC | |||||||||
50502 | Ford | Escape | Blue | 101 | 4 | AB2 | 3 LINE SVC | Chris | 3/30/2020 | 4/9/2020 | 84805 | |
| 105 | 1 | AA2 | 3 LINE SVC | |||||||||
| 1011.1 | 1 | 215z | 3 LINE CLR | |||||||||
| 1051.1 | 1 | 314z | 3 LINE CLR | |||||||||
| 1051.2 | 1 | 11sz | 3 LINE CLR | |||||||||
50503 | Toyota | Camry | Silver | 101 | 1 | AB2 | 3 LINE SVC | Steve | 3/31/2020 | 4/9/2020 | 010810 | |
| 1011.1 | 1 | 215z | 3 LINE CLR | |||||||||
| 1051.1 | 1 | 314z | 3 LINE CLR | |||||||||
| 1051.2 | 1 | 11z | 3 LINE CLR | |||||||||
50504 | Ford | F-150 | Black | 1011 | 5 | z2z | 2 LINE SVC | Alex | 4/1/2020 | 4/9/2020 | 515008 | |
| 1012 | 1 | z3z | 2 LINE SVC | |||||||||
| 1013 | 3 | z4z | 2 LINE SVC | |||||||||
| 1014 | 2 | z6z | 2 LINE SVC | |||||||||
| 211 | 4 | 3sz | CLR | |||||||||
50505 | Dodge | Challenger | Silver | 212 | 4 | 3sw | CLR | Charlie | 4/2/2020 | 4/9/2020 | 00156 | |
| 213 | 2 | AW1 | CLR | |||||||||
| 214 | 2 | Aw6 | CLR | |||||||||
| 215 | 1 | z9z | MXA X | |||||||||
| 1051 | 2 | zc5 | MK4 | |||||||||
50506 | Chevy | Malibu | White | 1052 | 1 | zc6 | RGw | Brian | 4/3/2020 | 4/9/2020 | 10510 | |
| 1053 | 1 | zc7 | Feg | |||||||||
| 1161 | 2 | zd6 | RTG | |||||||||
50507 | BMW | 640i | Red | 1162 | 2 | zd7 | GXR | Steve | 4/7/2020 | 4/11/2020 | 3215 | |
| 1052 | 1 | zdQ | GSE | |||||||||
50508 | BMW | 440i | White | 1011 | 3 | z2z | 2 LINE SVC | Jerry | 4/8/2020 | 4/11/2020 | 12131 | |
| 215 | 2 | z9z | FEM | |||||||||
| 1051 | 1 | zc5 | PLG | |||||||||
| 1161 | 4 | zd6 | RWE | |||||||||
| 1162 | 2 | zd7 | ETW | |||||||||
| 107 | 6 | ZC4 | SSR |
