Hi Guys,
I have a worksheet with two sets of columns differentiated by color "yellow" that should not change and "blue" which can be changed either from " " to text/# or from text/# to text/#.
I have included the sample sheet. for reference.
Now i am trying to write a macro that gets activated after a value is changed in a cell under any "blue" column and it does following"-
- Lets say we changed cell F9 to " better pen".
- Now my macro goes and looks at the value in cell "B9" i.e "b" and find all the rows in the sheet with the same value in column "B" like rows 4,10 and 11
- Then a MsgBox comes up asking me "If i would like to make this change to row 4, with option " yes" or " no".
- If i choose " yes", it copies value of F9 to F4, otherwise if i say "No" this MsgBox closes and nothing happens.
- Another Msgbox comesup asking me the same question for row 10 and this continues untill the macro goes through all the rows.
I have included the sample sheet. for reference.
I will really appreciate any help on this. I have been struggling to do this.
Thanks.
Roop.