Multi-Criteria Test - then put an X in a cell

Hello,

I am having trouble creating a macro that will work through all employees in a list, and put one "X" in a particular cell of a multi-column checklist based upon certain criteria. (see attached image.)

One number that will be required is a year that is entered by the user on a different page This value is found in this cell: MeetingDataSheet!B3

Here is the criteria:

If the YEAR cell on the employee list is empty OR an X is found in the IN THE USA cell of the same page, go to the next employee.

Otherwise
If the value in the MeetingDataSheet!B3 field - the year in the YEAR field is > 5 then put an X in the REQUIRED field, then go to the next employee.

If the value in the MeetingDataSheet!B3 field - the year in the YEAR field is 5 or less, then put an X in the NOT REQUIRED field, then go to the next employee.

Thank you very much in advance for your help.

Mike