Updated: Require input to non-adjacent cells in a tab if cells in another tab are filled?

As you can see in the attached spreadsheet, there are two tabs with data: By Major and By Concentration. Now if someone enters a number to any of the three cells H18, I18, or M18 in the By Major tab, I want to prevent the person from closing the spreadsheet without entering numbers to all of the columns C, E, F, G in the By Concentration tab for at least one row. For example, if someone has entered "6" to M18 to the By Major tab, I want the person to also enter numbers to C, E, F, G in the By Concentration tab for at least one row (e.g., row 5). If the person tries to close the spreadsheet without entering the required numbers, I want a message saying he needs to enter the required numbers.

It is my final goal above, and now I even can't have the basic of the basic working. I have the code below, and apparently something is wrong. If someone could please help me, I'd greatly appreciate it.

Thank you very much in advance!

Please Login or Register  to view this content.

Hi yl41012

Your attached File has unreadable content...please upload again.
Also, please wrap your Code in Code Tags...it's a Forum requirement.

Hi yl41012

I'm unable to sort out your requirements when I look at the attachment...did you attach the proper File?

Hi yl41012

Based on my understanding of your stated requirements, I can't see how to get from here to there.

I'm

unable to sort out your requirements

Sorry