Validation...

[Guest]

Hi,

I have created a validation in column A:A.
It is possible to copy & paste any other data in column A (instead of
validation data).
Is there any formula with which we can restrict the data that we enter in
column A i.e., data only as per validation should be accepted (no copy &
paste should be accepted).

Cheers,
Mandeep

 

[Peo Sjoblom]

No, validation only works for keyed data, not pasted

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Guest]

Hi Peo,

I have tried time and again and every time I try to copy paste any other
data in the field where validation is done, the copied value gets pasted in
validation fileds.

I want that only details in validation should only be selected.

I know we cannot enter any other data manually, but yes we can copy paste in
validation filed.

Cheers,
Mandeep Dhami

 

[Dave Peterson]

Maybe you can paste directly into the formula bar.