Inventory management help needed. Scanning like numbers into spreadsheets

Hello all I am new to the Forums and have found them extremely helpful. Thank you all so much for asking and answering questions I have been trying to solve.
The problem I am having is this. I am setting up a scanner to manage a parts inventory. I use the vendors bar codes which makes my job a bit easier and less expensive. This is working great other than we have parts that date back a few years at which time the vendor added a " -0000 " to the bar code part numbers. The barcode numbers are " XXXXX-XXXXX " and " XXXXX-XXXXX-XXX ". I would just have the scanner ignore the digits however as you can see some of the part numbers have " -XXX ". The part numbers are letters and numbers combined IE 99500-15234-F01 or K1245-67890. With the older bar codes the previous part numbers read " 99500-15234-F010 or K1245-67890-0000 " The module I have pulls the part number and description from page 2 into the working page and adds +1 to the quantity. Every time the same number is scanned it adds +1 to the quantity. I am wondering if there is a macro/ module I can run to solve the extra digits added so my inventory sheet does not need an extra step when completed. I am using a module found on this site by one of the members. I have attached a copy of the code so you have an idea of what I am working with.
To simplify. I scan XXXXX-XXXXX and get XXXXX-XXXXX-0000 or XXXXX-XXXXX-XXX and get XXXXX-XXXXX-XXX0 only on older bar codes. I have the same part purchased years apart with the same part number only the old one adds the -0000. I hope I was clear enough. ANy help would save me. Thank you.

Please Login or Register  to view this content.

If I scan part number 99023-12654 or 99023-12654-0000 which are the same item I want it to only add to one field 99023-12654. Right now it adds a new line. I can not just leave off the last 5 (-0000) as some parts numbers do have an additional -XXX ie 99023-12654-019.

Yes that is correct. My parts files are mainly 11 digit and some 15 digit.

Thank you so much for taking your time for this. I am going to implement it today. I will let you know how it goes.

Well I am having an issue implementing. I am inserting this into the active ws with no effect. You will have to forgive me I am leaning as I go. I have spent about 2 hours this morning trying to make it work on my own so I would not have to bother any help would be great. I will attach my workbook.

Here is a copy of my workbook. Thank you for any help.

From what I understand the code provided will edit the Inventory Sheet. My inventory sheet is in the correct format IE 11 digit or 15 digit. The problem I have is with the number being scanned into INV Taken Sheet. It wants me to set up a new item even though the item is already set up in the correct format.

Place this under the red line in your module:

Please Login or Register  to view this content.

Gosh Thank you so much. That does exactly what I need it to. You guys are great. Your time is very much appreciated.