I am working with CR9 and am creating a report. The report consists of two excel worksheets that I am trying to link together.
The report I am trying to create lists almost all employees and their annual salaries. The first excel spreadsheet contains one column labeled SSN and another column labeled Salary.
The second excel report has only one column, SSN. This spreasheet includes all employees SSN's that I do now want to pull into the salary report.
The common link between the two spreadsheets is the SSN, this is not a problem. My problem is that I do not know how to link the two to say, "Include all employees whose SSN doesn't equal one of the SSN's in the second spreadsheet."
Thank you in advance.
The report I am trying to create lists almost all employees and their annual salaries. The first excel spreadsheet contains one column labeled SSN and another column labeled Salary.
The second excel report has only one column, SSN. This spreasheet includes all employees SSN's that I do now want to pull into the salary report.
The common link between the two spreadsheets is the SSN, this is not a problem. My problem is that I do not know how to link the two to say, "Include all employees whose SSN doesn't equal one of the SSN's in the second spreadsheet."
Thank you in advance.