Wow this is nice.. I was expecting that when Yes is selected the rest will just set as No manually.
This one is great that whenever the Yes is selected the other will turn into No automatically.
Thank you so much @vletm for helping me on this.
Irelyn
You asked Your thread in VBA Macros, then You would get as You asked.
Do Your used we mean some group there? If so, then of course You can do it.
Hi @vletm yes actually I want to use VBA Macros on this however when I tried to do it in my working file, the changing of Yes into No seems not working well. Sorry for the confusion, I used the word we not for some group here, I used it as You and I.
If it is not too much to ask, can you check my VBA scripts as I know there is something wrong. Thank you in advance.
Basically the validation should be when I select Yes in one of the Financial Management simple, medium or complex the other 2 will set to No. Same validation to when I select Yes to Dunning simple or medium only one should be in yes and also in Advanced Order Management SIMPLE or Medium.
I would like to ask on how I can hide and unhide the rows in a locked sheet? I have attached again the file the we use before and the only problem now is that whenever I tried to locked the sheet, the hiding ang unhiding of rows for AMO Package is not working anymore. The password is 123. Appreciate your help again on this. Thank you in advance.
Irelyn
With which setting did You try to lock?
If You would like to hide row then there should be allow to [un]hide rows.
I added that missing functionality. Hint: Those Sheet1's cells should unlocked, which users needs to use. If users can ... do what ever ... then user would do so.
That one is amazing! I think I can also use that logic for future reference. But what I want is to have the same logic in column C to be apply as well in column H and column M.
Example:
In column C, the row 7 and 8 will only chose 1 yes.
If I select Yes in row 7, the row 8 should stay as No and vice versa.
This logic should also apply in row 13&14, 15&16, 17&18, 19&20, 65-67, 68-69, 71-73
I have attach the file that I added some formula but I don't know what I am missing.
Again thank you in advance for helping me on this.
Irelyn
You missed totally my made code.
Your #13 reply file has two groups of row to take-care.
... others were maybe hidden or so.
You can see my code and add those missing row-groups.
I tried your code and added those missing row-groups and it is working now.
However, there are some issues occurred like:
* column C rows 9-12, and column H rows 17-18, these rows can all select Yes and should not auto change the other cell to No.
* column M rows 6-7, these rows cannot auto select No when selecting yes
Irelyn
Do those three columns C, H & M have different 'row-groups' for those "yes/no" -rules?
If so, then I should know - what are those?
or
You should get an idea - what have You done? ... what You should do?
Just now - that code do not work ... well! .
.. or actually as every code, it'll work as it has written.
Yes those three columns C,H, & M has different row-groups for the "yes/no".
In the sample file3.xlsm that I have attached, I put different color on every row-group (col. B,G & L) that should be select only 1 "yes" and automatically set the other into "no".
I have also attached notepad of the row-group for the "yes/no" per column for your reference.