Excel data comparison and copy data [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,
Sheet1 details
A:employee no (employee no appear more than once) (a2:a5720)
B: name
C:address1
D:address2
E:address3
F:address4
G:pin

Sheet2 details
A:employee no (selected employee)

I want that employee no in the sheet2 should be searched in the sheet1 and if it matches then copy the data from "b to g" of the sheet1 in the sheet2 in same fashion as it is appearing in the sheet1. Please help me

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
why is the employee number is appering more than one.

does address1,2 3 etc appear in the same row or different rows for particular name

if possible post a small extract of sheet1

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!