Expert validation...?

merlin_the_magician

Active Member
Joined
Jul 31, 2002
Messages
480
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
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Ian Mac

MrExcel MVP
Joined
Feb 20, 2002
Messages
1,174
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

Active Member
Joined
Jul 31, 2002
Messages
480
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
 

Forum statistics

Threads
1,144,359
Messages
5,723,893
Members
422,524
Latest member
wirkkarn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top