Excel compare and copy the data intersheet

Closed

balu - 28 Jul 2011 à 13:05
Charlie - 29 Nov 2012 à 16:03

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

Excel compare and copy the data intersheet
Beyond compare - Download - File management
How to copy data from one excel sheet to another - Guide
How to merge and compare two excel files - Guide
Export data from excel - Guide
How to copy data to multiple worksheets in Excel - Guide

2 responses

Réponse 1 / 2

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
28 Jul 2011 à 16:11

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

balu
31 Jul 2011 à 13:48

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

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
31 Jul 2011 à 19:11

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

balu
31 Jul 2011 à 22:21

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

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
1 Aug 2011 à 16:42

you can upload to some shared site. like google etc and paste the link to file back

Réponse 2 / 2

Charlie
29 Nov 2012 à 16:03

Thank you very much!

Similar discussions

Copying data from one Excel sheet to another.

How to extract data from one excel file to another

Hosted app data will not clear

Similar discussions

Subscribe To Our Newsletter!