PARKING TICKET LOG HELP Please and Thank You!!

[FrontDeskSRE]

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 duplicate listed in one column of the log. If possible, also have the data only pulled if it is from the past 12 months/year. 

[#2]

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

@FrontDeskSRE 

[#3 · Accepted solution]

@FrontDeskSRE 

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.