VBA Macros to force user to fill all the mandatory fields

Hello Again,

Sometime bosses request staff unusual assignments to be fulfill. Requesting for a critical format of excel file which is related to user security control to fill all the required details. The data will be filled for dynamic range due to 50 to 60 hundred thousands records (Can be more or less). Appreciate if some 1 can help me out.

I am looking for a file with can control a user with the following.


1. Validation will start once the user fill the cell value in column A
2. Cursor must not move to next row until user fill all required cell until column X (Enter key disable & Tab key function enabled).
3. Column F is mandatory field - User should not move to next cell until enter string in column F cell value.
4. If the benefits in Column H is Dental, Optical or In-Patient then approval number is mandatory and cursor will got column G and force the user to enter (Not left blank).
5. Column K is mandatory field - User should not move to next cell until enter string in column F cell value.
6. If benefit is dental in column N then tooth is mandatory in column O.
7. Formula will be return automatically in column R if the values entered and press tab in column P & Q

Copy of the file is attached with sample data.

Can some1 help me on this file please.