Using Data Validation to ensure unique values across more than one work sheet

[steve_l]

Hi,

I require a coloumn on my spread sheet to only accept unique values.

I have got it working on a single sheet of my workbook but would like it to be able to check that the value is unique across multiple worksheets.

The code I have so far is :

Please Login or Register  to view this content.

How could I modify this to include the checking the values across another worksheet
(the cell numbers would remain unchanged from the initial worksheet)


Many thanks in advance!

[Fotis1991]

Ηι

I made an example where the sheets 1 & 2, there are values ​​and Sheet 3 in column A are unique.

Take o look to the attachement