2 pull down menus mirror each other

[pick-six]

I have two pull down menus using data validation and lists. It is a simple yes or no list. The menus are located on different sheets but when one is changed or selected, I want the other pull down to show the same value. Is there a code or another simple way to do this?

[mehmetcik]

Use a sheet specific macro on each sheet

Right Click on your Sheet1 and select view code.
Paste this code in the visual basic module and close it

This links cell A1 to cell B1 on Sheet2

Please Login or Register  to view this content.

Right Click on your Sheet2 and select view code.
Paste this code in the visual basic module and close it

This links cell B1 to cell A1 on Sheet1

Please Login or Register  to view this content.

Patse this code into a macro module

Please Login or Register  to view this content.

[pick-six]

Thanks mehmetcik your code works. My only question is why can't I see the last code when I go to developer then macros. If I needed to delete the code in the future how would I do that?

[mehmetcik]

The last code should be in a macro module

select developer

select visual basic

select view and the project explorer

the "Modules" are your normal macro modules, double click on them or right click and select view code to see them
the "Sheets" are your sheet specific macros, double click on them or right click and select view code to see them
"this workbook" contains your workbook wide macros, any macro here will work in all sheets.

[pick-six]

Thanks again!