K
Karen271077
Please help me I have a problem with Excel
I’m currently running some Employee reports from SAP. All Employees
have two records, the only thing that is commen is their Name … I would
like to take one piece of information from one report and add it to the
corresponding employee in the other report.
For example
Workbook 1
Column A = Name EE
Column B = International EE number
Column C = Personnel area International
Column D = Needed data from Workbook 2 = Column C (Personnel area
Local) in workbook 2
Workbook 2
Column A = Name EE
Column B = Local EE number
Column C = Personnel area Local
I’m currently running some Employee reports from SAP. All Employees
have two records, the only thing that is commen is their Name … I would
like to take one piece of information from one report and add it to the
corresponding employee in the other report.
For example
Workbook 1
Column A = Name EE
Column B = International EE number
Column C = Personnel area International
Column D = Needed data from Workbook 2 = Column C (Personnel area
Local) in workbook 2
Workbook 2
Column A = Name EE
Column B = Local EE number
Column C = Personnel area Local