Previous Topic Next Topic

Excel compare and copy the data intersheet

Closed
balu - Jul 28, 2011 at 01:05 PM
 Charlie - Nov 29, 2012 at 04:03 PM
Hello,

i have sheet1 wherein employee no in cell A1 and the data is in A2 and downward and B2 first name, C2 middle name, D2 surname, and complete address in the rest column and in the sheet2 I have employee no in A2. I have a few employee no in the sheet2. I want to compare the sheet2 employee no with that of sheet1 and if both mach then copy the other cells values of sheet1 in the sheet2 in the same fashion as in the sheet1. please help. I donot know how to use macros in the excel.


urgent
Related:

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 28, 2011 at 04:11 PM
You need to use VLook up.
in Cell B2 of sheet 2 you can write (
=VLOOKUP(A2, 'Sheet1'!A:E, 2, false)

A2: cell address for which you want info from sheet 1
A:E columns where data is on sheet 1, "A" MUST be the column where the match must occur
2: In range A:E, if there is match in column A, then get me data from 2nd column (column B)
FALSE: I want exact match
1
balu
Jul 31, 2011 at 01:48 PM
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
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 31, 2011 at 07:11 PM
Upload a sample file with some sample data that would show how the data is right now and how you want to see. Upload the file at some shared site and post back the link to the file back here
0
balu
Jul 31, 2011 at 10:21 PM
I want to upload the required excel sheet. then how to do the same as there is no option I find to upload the same
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 1, 2011 at 04:42 PM
you can upload to some shared site. like google etc and paste the link to file back
0
Answer 2 / 2
Charlie
Nov 29, 2012 at 04:03 PM
Thank you very much!
0

Similar discussions

Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses