I am having trouble coming up with a VBA code to find a part number I am searching for and then finding the highest (or last row) serial number, adding 1 to that number and creating a new line item.
<tbody>
Part Number
Serial Number
Description
5462H
023
Pan Head Screw
6524X
018
Washer...