G
Guest
I have 2 worksheets that I would like to merge all the data into 1.
Both these worksheets are a listing of staff names, job title, department
and the hours they have worked in the last 6 months.
I want to merge these worksheets so that I am able to have all the info for
each employee from both worksheets on 1 row in another worksheet. The
problem is worksheet 1 and 2 don't have all the same staff listed - as new
people are hired and others leave.
Hope that is enough information that someone is able to help me.
Joan
Both these worksheets are a listing of staff names, job title, department
and the hours they have worked in the last 6 months.
I want to merge these worksheets so that I am able to have all the info for
each employee from both worksheets on 1 row in another worksheet. The
problem is worksheet 1 and 2 don't have all the same staff listed - as new
people are hired and others leave.
Hope that is enough information that someone is able to help me.
Joan