I have three worksheets. One is where I enter all my employee data, the
second is a template which is automatically populated when I input the
employee name in the third sheet. Also, the third sheet contains a list of
employee names and a macro that will automatically populate and print the
template when I put an "X" in the column next to the employee name. So if I
wanted to print twenty specific employee templates, I can check off the
twenty that I need to print.

Now my problem is, not all employees have the same data. For example, some
employees are paid on a weekly basis, some bi-weekly and some monthly. In my
employee datasheet, there are 3 columns to input this information and only
one column is filled in. Rather than to have my template show weekly,
bi-weekly and monthly, I want to show just weekly if the employee is paid
weekly, or just show bi-weekly etc. Is there anyway to tell excel to look in
those columns for a number, and to show that name (either weekly, bi-weekly
or monthly)?

Hope I am clear. Thanks for any help.