Expert validation...?

[merlin_the_magician]

Right… posted a question on this a few days ago already, but I think things are starting to get just a little more complicated than the matter actually is. I will explain the thing again, in very simple, plain words. Hopefully this helps understanding the problem better.

Imagine this:

I have two columns, M and N. These are validated, so only the number “1” can be entered in the cells.
One should only be able to fill out eighter column m or N, not both of them. Also important: the validated value “1” is something I will need to keep!
How can I fix this? VBA code? More specific validation?

Hope somebody can help me out here!

Kind regards,
Merlin

 

[Ian Mac]

On 2002-09-04 03:29, merlin_the_magician wrote:
Right… posted a question on this a few days ago already, but I think things are starting to get just a little more complicated than the matter actually is. I will explain the thing again, in very simple, plain words. Hopefully this helps understanding the problem better.

Imagine this:

I have two columns, M and N. These are validated, so only the number “1” can be entered in the cells.
One should only be able to fill out eighter column m or N, not both of them. Also important: the validated value “1” is something I will need to keep!
How can I fix this? VBA code? More specific validation?

Hope somebody can help me out here!

Kind regards,
Merlin

Ok sorry to be abrupt BUT I have answered this question spent a lot of time explaining and explaining.
I have offered to look at your Workbook if need be.
My method works, yet you seem a little ungreatful.

Sorry if this out of order, but I spent a time span of aprox 16 hours from first to last post AND posted the morning.

If you could just send the book I'll show that it works.

Also you should carry on in the same thread:

http://www.mrexcel.com/board/viewtopic.php?topic=20885&forum=2&start=0
_________________
Share the wealth!!
Ian Mac
This message was edited by Ian Mac on 2002-09-04 03:55

 

[merlin_the_magician]

Im very sorry Ian,
i did not mean to be rude or ungreatfull. I really appreciate the help you offered. I just figured that maybe i should ask my question again, and try to explain things more clearly.
I will not edit this post anymore and dtick to my original posting.
If you check your mailbox, you will find my workbook.

Merlin