Automatically fill in a dropdown selection based on a previous dropdown

Hello there,

Thank you for spending your time reading this.

I've been trying to solve this for a couple days but got to nowhere. So the problem is let's say I have 2 columns, one named Group and one is Response
Group Response(Yes/No)
A
A
B
B
C
C

My goal is to create a drop list with Yes/No option for the Response columns for every row, and if I choose Yes for the first row of Group A, the second row of Group A also turn YES. Also, if I choose Yes for the second row of Group A, the first row of Group will become Yes, same ideas with Group B and C, and I have more than 1k different groups. Basically, I want to have same answers (Yes or No) within the same group, and doesn't matter which one we click first for the drop down list.

I tried to create a new sheet and used Vlookup, it worked well to return all answers as groups but it doesn't meet the requirement. They want to show the drop list on each row of the Response Column and make changes from there.

Sorry I didn't know a better way to describe this problem. I hope to get help from you all. Thank you so much!

Hello,

Thank you for your quick response. However, this is not what I was looking for. Let me explain it again here.

So the Group A,B,C,D are default values. I already created drop down list with Yes/No option for all the rows in Response Column. What I want is when I select Yes from the drop down list for first row in Group A, it will automatically make all the other drop down within Group A same values (Yes).

So within every group, if you make one change of any random row within that group, it will give the other row in the same group same values (Yes or No).

Please advise!

because let's say they insert another column (ID) before the Group, when they use filter and sort it, the B2 will disappear. So I am trying to set up the dropdown for every row, so it doesn't matter how the user filter, there's always options for them to choose.

as I mentioned, I used vlookup with a backend-sheet and this works just fine, but the requirement of the task is to have dropdown for every row. Please share your thoughts. Thank you!

Hello,

You're the best. Thank you so much for helping this is exactly what I need. May I ask another question? So do I have to put these two columns next to each other in order for them to work? if I have more columns in between, with layers of different filters, what should I change in the VBA code?

Again, thanks so much!!!!

Hi,

That works perfectly for me, thank you again so much. Let's say later I want to add 3 more columns G,H,J and for the H,J if they have same group in G, they will return Yes/No like the problem we just solve. How can you add another code for the VBA? Thanks

Hello there,

Thank you again for your help, I do have one last question though :D.

It's about filtering. So let's say we still have the Group and Response Column, now I add Customer Name and Location columns to it. My goal is it doesn't matter how I filter my sheet, it will return same answer for Response column for all filtered sets and only affected those filtered cell. As of right now, since on the VBA code it only shows the connection between Group and Response so if I add more column and filter them, it won't work.

Please advise and again thank you so much. Your answers been helping me so much! Thanks!