How to auto add 1 to a specific cell when the same value is entered. For inventory mgmt

Hi,
This is a scenario for simple inventory management. I received items that need to enter into a spreadsheet. Each item has a unique identifier (SKU) stored in the same workbook. However, the items I receive are not sorted, they are scattered, imagine all kinds of fruits placed in one box.

So when I scan (or type in) an SKU number, an item shows up in A column and recorded '1' in the C column.
1.jpg

What I want to achieve is that, at some point, when I entered an SKU, the existing same item add 1 automatically and removes the one that is being entered.
2.jpg

Thanks so much for the help!

.
Please paste your existing macros.

The required code will need to be placed within one of those macros.

Hi Logit,

Thanks for the reply, actually I don't have any macros for this spreadsheet. How I'm currently doing is just scanning through all items (of course, the C column will be always '1'), and ended up with a huge long list with duplicated items. So I was wondering if there is a smarter way of doing it.

Maybe the below in the worksheet module..

Please Login or Register  to view this content.

See attached.

BSB

Hi BadlySpelledBuoy,

This is exactly what I'm looking to achieve. The problem solved in 10mins.

Huge thanks guys for all your help!

Glad I could help

BSB

.
I'm not clear how the Worksheet_Change is able to determine a value has changed ?

The scanner is picking up the SKU number and presumably some piece of software is searching for the same on the Inventory Sheet.
However, if I correctly understand, nothing is changing on the sheet at that point ?

.
Well ... guess my question didn't have any value.