I need a macro to help me streamline a very manual process. I don't know how to write them, but I know how to used them.
It's Salary Planning season and I have to download a list of employees on a regular basis and determine who's eligible or not. It's a very manual process with a lot of vlookup tables. With close to 30k employees, it takes a long time for the formulas to calculate (approx 20 - 30 minutes at times)
Attached is a file with my formulas and all the eligibility rules.
I love to have a macro that will run and give me one column that list if that employee is "Not Eligible"
Column "Y" on my Data table has the employees that are not eligible
Row P1 - Y1 has my eligibility formulas, based on look up ranges.
Categories that determine eligibility are:
ESG - Employee Subgroup (There are exceptions to this rule, indicated in column P = TRUE, Q = TRUE, W = FALSE)
PA - Personnel Area = FALSE
ORG - Org Unit = FALSE
CC - Cost Center = FALSE
GRD - Grade = FALSE
The rules are also outlined in the eligible tab