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>
</tbody>
I want it to find "5462H" and then realize the last serial number input was 023. Create a new line shown below:
<tbody>
</tbody>
I am not inputting in text, just a click of a command button with the label "5462H"
Thanks
Part Number | Serial Number | Description |
5462H | 023 | Pan Head Screw |
6524X | 018 | Washer |
<tbody>
</tbody>
I want it to find "5462H" and then realize the last serial number input was 023. Create a new line shown below:
Part Number | Serial Number | Description |
5462H | 023 | Pan Head Screw |
6524X | 018 | Washer |
5462H | 024 | Pan Head Screw |
<tbody>
</tbody>
I am not inputting in text, just a click of a command button with the label "5462H"
Thanks