Please Do the following

Design a VBA macro called Car$-$Fees that does the following:

$*$ Resets the counts for the number of cars in each weight class $($cells K$4$ to K$11)$ to $0.$

Hint: use ActiveSheet.Range$("$K$4$:K$11").$ClearContents

$*$ Processes the list of vehicles provided and determines the weight class and registration

fee for each vehicle and displays that information in the corresponding columns

$*$ Displays the count for the number of vehicles processed in each weight class

Please follow order of cells:

Model year cell E

Weights cell F

Weight class cell G

Registration fee Cell H

Distribution Count cell K