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