I have a table somewhat like the following:
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