Change validation valure from 1 cell will change other validation value

[Rocky2013]

Hello,
I need help on when I select a data validation value in cell A3 of sheet 1 will change the data validation value
in A5 of sheet 2, and verse vice.

Also in the same attached file, I want to solve another formar issue. The needs is expained in the file.

Thanks you very much of your help

[dilipandey]

Hi Rockey,

Better to use a separate drop down and link A3 of sheet 1 & A5 of sheet 2, see attached:-

Excel help April 4, 2013.xlsx

Regards,
DILIPandey
<click on below * if this helps>

[Rocky2013]

Hi dilipandey,
Thanks for the reply. This is not exact what I want. I like to have the same validation on sheet2 (actual could be in any sheet even at sheet 20).
The reason I can make changes by selecting different value from validation on spot (sheet 2), without going back to sheet 1. Another way, I could do
is to add a dot (edit the value) with huperlink to sheet 1. Then going back to sheet 2 (if I remember the sheet because there will a lot worksheets)
to continue the work.

Regards,

[FDibbins]

If I understand you correctly, you want to have a DD/DV on 1 sheet (sheet1), and if you select an item from that DD, you want that same item to be shown in a 2nd DD on another sheet (sheet2).

OR if you select an item from rge DD on sheet2, the same item gets selected in the DD on sheet1?

If my understanding is correct, you cannot do this with regular formulas/fucntions - the reason being that a cell can either contain an entered value OR a formula, it cannot contain both. Wanting cell A1 to be dependant on B1 AND B1 to be dependant on A1 at the same time, is not possible with formulas.

As dilipandy suggested, it would be better to have a 2nd DD - you could even, in a cell next to each DD, have a reference to the other DD

[Rocky2013]

Hi Fdibbins,
That is correct A1 and B1 dependant each other. Can that be done in VB?

Thanks

[FDibbins]

Thats the only way it can be done, but my VBA sucks

[:) Sixthsense :)]

If it needs to be done for only 2 sheets then possibly I can provide you the code

But if it needs to be done for many sheets then the Validation Place should be constant or Need the cell reference on which the change needs to be reflected for each sheets

[Rocky2013]

Hi,
Can you please do it in two sheets?

Thanks

[:) Sixthsense :)]

Add the below code in ThisWorkbook code window

Please Login or Register  to view this content.

Refer the attached file for details.