use concatenate rule. e.g., =cellno&cellno of any workbook.

"Karen271077" wrote:


Please help me I have a problem with Excel

Im 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


--
Karen271077
------------------------------------------------------------------------
Karen271077's Profile: http://www.excelforum.com/member.php...o&userid=36195
View this thread: http://www.excelforum.com/showthread...hreadid=559836