Hi
If I have one workbook with say an employee data base containing names, salaries, date of employment, etc and say 1000 employees.
And I have another spreadsheet with exactly the same headings.
What is the simplest way to extract say all those employees with the name George (assuming george exists in the database more than once)?
Regards
PS thought of using a pivot, but not so easy.
If I have one workbook with say an employee data base containing names, salaries, date of employment, etc and say 1000 employees.
And I have another spreadsheet with exactly the same headings.
What is the simplest way to extract say all those employees with the name George (assuming george exists in the database more than once)?
Regards
PS thought of using a pivot, but not so easy.