3 columns - conditions - mandatory for filling with data

HI,


I have a table with 3 columns: quantity / unit measure / amount.

2 of them are mandatory to be filled with data (quantity and amount). If one of the columns has no data to be entered, "n/a" should be entered anyway. (message box for attentioning if empty)
The colum unit measure is manadatory if the column quantity contains a number.
If the column quantity contains "n/a", the column unit measure should be automatically filled with "n/a", but if the column quantity contains a number, for the unit measurecolumn a message should appear "please fill in unit measure".

please advise.

Thank you!

if possible, yes.

Hi, looks great.
I still have a problem with it ... if i paste more than 1 row (for ex I have a list to paste in and some data is missing) (and i will have the case) i have error message n line "If Target = "n/a" Then" ... can you also help with this?
thank you!

i cannot attach excel... I copied something here, if you paste it in excel, it's a bit more organized

ccode cname transaction detail

date:

info 1 info 2 info 3 quantity quantity measure amount info 4 info 5 the quantity and the amount - mandatory to be filled. If no data is to be entered, n/a shoud appear
row1 if quantity is a number, then quantity measure is mandatory
row2
row3
row4
row5
row6
…
the table an grow with rows



The columns marked with yellow are mandatory.
I could set them as mandatory, (A loop in a separate sheet, with the table heather lines markes with M, and there's a loop that looks up every range if marked with M and asks data to be entered). But in the case D5:F5, I have the issue, because the quantity measure should only be mandatory if the quantity is a number
I cannot send you my file, because is really big and contains lots of confiential data… sory
I on't know if the change can be used again … I already have a change by val, because the file contains lots of transaction details, and the table heather changes when the transaction detail is changing


Ranges:
FirstToBeFilled A6, set as mandatory in all cases - the form cannot be sent if this is empty
Table1 the table A6:H12, in this case

in the picture you can see the 3 possible cases that can appear when filling in data.


Capture.JPG

Hope it helps in helping me ... thank you for your time!

myfile.xlsx

i did it ... attached

The data entering always starts with A6. this cell is mandatory before any other cell is filled in.
If "N/A" is entered in D6 then E6 should also contain "N/A", and then in F6 the amount is mandatory. H6 (and many others in my form) is mandatory.
I only have the problem connecting these 3 columns somehow.

The example you made the first time, was ok, but it shoul work even if data is pasted from an another source.
your proposal: a macro to check the mandatory cells to make sure they are filled before allowing the file to be saved is what i need

In my form, i have many buttons. And one of them checks the mandatory fileds to be filled in. I just need to connect the 3 columns - i guess i just need the idea for this. I tought your first solution was ok, until I pasted the many data and it just stopped ...

thanks!

myfile.xlsm
attached with code.
thank you for your time!

Hi, I have checked the file, but it still isn't what i need... it works if it is filled line by line, but...
It has to be ok even for much data added from other data tables too.
All those message boxes are not ok. My users will not like it.
It should let the user fill in data, and when it signes for approval, if it's the case, fill in the n/a for the quantity measure if the quantity is n/a, and check if the unit measure is missing when the quantity is numeric. Also make the check for the amount not to be empty (should be n/a or amount - anounce the user in any case)

i am so sorry for bugging you this much ... i am just stuck with this problem and cannot move on