Data validation across sheets

[topbink]

Hi Everybody,

I tried to make data validation (dv) to prevent duplicated values in two sheets.

Here is what I need to do: When I put a value in "Sheet1 Column Trx_No" the dv will prevent duplication if its already in Sheet1 or Sheet2 Column Trx_No and also if I tried to put a value in "Sheet2 Column Trx_No" the dv will pops a warning if the value already exist in Sheet2 or Sheet1 Column Trx_No. And I have to keep those two tables separated.

Many Thanks,

topbink

 

[Somendra Misra]

Hi,

Can you check this file.

Regards,

 

[topbink]

Magic.... It really works the way I wanted.

Thanks so much @SomendraMisra

topbink

 

[Somendra Misra]

You are Welcome!!!

Regards,