Data Validation to check Dynamic range in another sheet

[Soniya]

Hi all,

I have a macro which copies data from an input sheet to
data sheet

for eg. I have A number in sheet1 A1 which will be copied
to sheet2 A1,a2,a3 etc


can i use a data validation in sheet1 A1 not to repeat
the same number which is already in sheet2 column A ? (
for each input sheet column a will have one more record.
so the number of rows is not fixed.

something like a datavalidation formula :

=indirect(countif("Sheet2!MyRange"))not morethan 1 ???

TIA

Soniya

 

[Tom Ogilvy]

Data validation only applies to manual entry of data. While it is not clear
what you want, it doesn't sound like you want to apply it to manual entry of
data.

 

[Soniya]

Yes Tom,

I want to apply it for manual entry of data..

only thing is that it should not accept a number which is
already entered in that cell which is sroed in the next
sheet in a specific column


Soniya