Data Validation - Linked to each other

[michelle 1]

Hi

I have posted on here as i think this may require VBA code and i was hoping someone may be able to help.

I have a spreadsheet with various tabs. I have a validation in cell C2 and one on another tab in cell D2. I am trying to get them to work in conjuction so whichever selection is made from either both will showthe same result, i need them both to be validations though. Is this possible?

Michelle

[MickG]

You can do this by using Two "Worksheet_Change event" Codes:- One code in each sheet.
Place in sheet1, Sheet Code Module (This Sheet have "Validation list" in "D2"

Please Login or Register  to view this content.

Place in sheet2, Sheet Code Module (This has Validation List in "C2")

Please Login or Register  to view this content.

[michelle 1]

Dear MickG

You are a genius, thank you so much for replying it works perfectly.

Michelle

[MickG]

You're welcome