I have a table somewhat like the following:

Code:
APPLE  1
BANANA 0
BANANA 0
ORANGE 1
APPLE  1
BANANA 0
Whenever I make a change in column B I would like all other cells in column B with the same type in column A to also change. So if I changed B1 to '0' then B5 would also change to '0'. If I changed B2 to '1' then B3 and B6 would also change to '1'.

Unfortunately, I don't really have the first clue where to start with this. I am thinking I will use Worksheet_Change, but that's as far as I've come.

Any help very much appreciated