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.

--
Regards,
Tom Ogilvy


Soniya wrote in message
...
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