PDA

View Full Version : Changing values based on offset values



freded59
03-06-2017, 10:01 AM
colA
colB


Test
a



b



c



b



b



b


Test
a



c


Test
a




I am trying to make a private change function regarding the example above. When a value is changed in colA I want all of the values in colA with the same value in colB to change as well. For example if a change was made to "Test" in either location they would all change. Let me know if anyone has any advise on this. Thanks!

SamT
03-06-2017, 11:54 AM
More info please

freded59
03-06-2017, 12:11 PM
So say the first cell with a value of "Test" is A2 and the one to the right with a value of "a" is B2. If I were to change the value in A2 from "Test" to "Live" I would want the values of A8 and A10 to be "Live" as well because they all have the same value in column B. And this is just an example, I would need it to work with all matching values in column B no matter what the values are.

It is my understanding that this can be done with a Private Sub Worksheet_Change I just am not sure how to do it.