Previous Topic Next Topic

Merging two excel sheets

Closed
savgeorg Posts 6 Registration date Friday November 1, 2013 Status Member Last seen November 5, 2013 - Nov 1, 2013 at 03:48 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 12, 2013 at 10:50 AM
Hello guys im totally new here and i want to ask a question.
I have two excel sheets that i want to merge. Let me explain what i want to do and i hope u understand.
Both of them have one column let say column C the same.
I want a macro that checks column C identifies the same numbers that i have written in column C on both sheets and then to copy from the second sheet everything that is written in Column D and E to sheet 1 next to Column C.

Example

Sheet 1:
Column C

4002919-6
4002515-8
7215444-6
7235445-7

Sheet 2:
Column C Column D

4002510-6 TEST1
4002515-8 Test2
7216455-8 Test3
7215444-6 Test4

I want to find the same numbers from Column C and then to sheet 1 to copy the contents of Column D. Whenever there is no match field to leave Column D in Sheet 1 empty.

I hope u understand what i mean.

Thanx a lot
Related:

8 responses

Answer 1 / 8
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 1, 2013 at 08:20 PM
you can use vlookup
0
Answer 2 / 8
savgeorg Posts 6 Registration date Friday November 1, 2013 Status Member Last seen November 5, 2013
Nov 2, 2013 at 12:21 AM
i tried but it gives me error all the time
anybody can help me?
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 2, 2013 at 07:44 AM
try some thing like this
=VLOOKUP(C1,Sheet2!C:E, 2, FALSE)
0
Answer 3 / 8
savgeorg Posts 6 Registration date Friday November 1, 2013 Status Member Last seen November 5, 2013
Nov 2, 2013 at 09:16 AM
Again gives me error.
I went to column D i paste this and the error is this #NAME?
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 2, 2013 at 09:25 AM
see this to see if it helps in resolving your error
http://office.microsoft.com/en-us/excel-help/correct-a-name-error-HP010342326.aspx
0
Answer 4 / 8
savgeorg Posts 6 Registration date Friday November 1, 2013 Status Member Last seen November 5, 2013
Nov 3, 2013 at 01:14 AM
i read this already and i also read some other topics here that they tell about vlookup but didnt help. Is it possible to send u the file and check it for me please?
Thanx
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 3, 2013 at 07:50 AM
you can upload the file at some file share site like speedyshare etc and post back the link to the FILE itself back here
0

Didn't find the answer you are looking for?

Ask a question
Answer 5 / 8
savgeorg Posts 6 Registration date Friday November 1, 2013 Status Member Last seen November 5, 2013
Nov 4, 2013 at 01:10 PM
hell my friend and thanx for helping me
the link is http://speedy.sh/HxmrK/FILE2.xlsx
thanx a lot in advance
0
Answer 6 / 8
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Nov 5, 2013 at 11:41 AM
Hi Savgeorg,

To keep the cell empty when there isn't a match I added the ISERROR function to the formula of Rizvisa:

http://speedy.sh/e6Ska/Savgeorg-FILE2.xlsx

Best regards,
Trowa
0
Answer 7 / 8
savgeorg Posts 6 Registration date Friday November 1, 2013 Status Member Last seen November 5, 2013
Nov 5, 2013 at 12:12 PM
Thanx Trowa this is exactly what i want :)
One last question. If i want to add all the columns after Column C not just Column D what i should write on your formula?
0
Answer 8 / 8
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Nov 12, 2013 at 10:50 AM
Hi Savgeorg,

You mean like this?:
http://speedy.sh/Fwjde/Savgeorg-FILE2-V2.xlsx

Best regards,
Trowa
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to merge WhatsApp backup from old phone to same WhatsApp
WhatsUpWae -
HelpiOS -

1 response
Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses