Forum Discussion
Solved
PARKING TICKET LOG HELP Please and Thank You!!
I have a log of parking ticket data. I would like to have a list of tickets that have been issued to the same vehicle plate number. In other words, have a row copy onto a new tab if there is a duplic...
You can try Power Query. In the blue dynamic table you can add data. Then you can click in any cell in the green table, right-click with the mouse and refresh.
| Ticket # | Issued Date | Location | Time | Plate# | Vehicle Make/Model | Photo on File | Ticket Writer | Off-Duty | $ Ticket Amount $ | Voided Reason | Priors (P) or (NP) | Pmt. Date | $ Pmt. Amount $ | Notes |
| 10103 | 01/05/21 | 3224 Lower Lot | 1245 | BUR1234 | Honda Civic | $20.00 | ||||||||
| 10104 | 01/06/21 | KBT #34 | 855 | 209123 | Toyota Prius | $20.00 | ||||||||
| 10105 | 01/07/22 | KBT #51 | 900 | BCB1234 | BMW XI | $20.00 |
You can try Power Query. In the blue dynamic table you can add data. Then you can click in any cell in the green table, right-click with the mouse and refresh.