Excel data comparison and copy data

Closed
balu - Jul 31, 2011 at 01:47 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 1, 2011 at 06:36 AM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 1, 2011 at 06:36 AM
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
0