Combining Data, Excel .xlsx

W

webscraper

Newbie

Jun 24, 2013

19

3

• Oct 28, 2013

• #1

I want to be able to have something that does this on my own through Excel Macros or something. Here is what I need

I have 2 excel sheets..

Sheet 1 has Company Name, Address, Phone,Url, Email (email column is blank)
Sheet 2 has Url, and Email

I need to be able to combine the 2 lists filling in the emails in the right column with the url name being the deciding factor.

I hope this makes since!

Skype Me: trackmafia

 

M

mthree

Newbie

Nov 29, 2011

8

3

• Oct 28, 2013

• #2

Sort both sheet one and sheet 2 by url descending or ascending but the same on both sheets

then copy and paste the emails column from sheet 2 to sheet 1

I am presuming you have the same number of entries in each sheet

 

W

webscraper

Newbie

Jun 24, 2013

19

3

• Oct 28, 2013
• Thread Starter Thread Starter

• #3

The problem. Is there is not an email for some of the rows. So this wouldn't work :/

 

ContentWriter

Banned - Selling via PM

May 8, 2013

5,735

975

• Oct 28, 2013

• #4

I added you on Skype. Let's chat ASAP so I can deliver this ASAP, too.

 

M

mthree

Newbie

Nov 29, 2011

8

3

• Oct 28, 2013

• #5

do you have the same amount of URLs in both sheets ?

 

ardley216

Elite Member

Mar 28, 2008

2,389

2,418

• Oct 28, 2013

• #6

ITs very easy to do it with CSV files.

Use CMD, and use:

Code:

copy *.csv name.csv

Then open it back up in excel.

I did this to combine csv files with millions of lines.

 

M

mthree

Newbie

Nov 29, 2011

8

3

• Oct 28, 2013

• #7

that would only combine 2 or more csv files into 1 csv file.

He has only 1 csv file but 2 tabs inside the file

 

J

jp_smith86

Senior Member

Jul 6, 2012

1,077

413

• Oct 28, 2013

• #8

Too easy. use vlookup function buddy. I can do this free of cost. add me on skype.

 

M

mthree

Newbie

Nov 29, 2011

8

3

• Oct 28, 2013

• #9

jp_smith86 said:

Too easy. use vlookup function buddy. I can do this free of cost. add me on skype.

Click to expand...

True very easy .

 

W

webscraper

Newbie

Jun 24, 2013

19

3

• Oct 28, 2013
• Thread Starter Thread Starter

• #10

jp_smith86 made this happen for me !!! Thanks guys

 

kung fu panda

BANNED

Oct 10, 2013

415

103

• Oct 29, 2013

• #11

added on skype.

 

gokulvikas

Junior Member

Nov 16, 2010

127

16

• Oct 29, 2013

• #12

It's very easy. Just use vlookup function in excel. Or add me at skype gokulvikas1986

 

B

blackhat777

Elite Member

Jun 25, 2011

1,784

671

• Oct 29, 2013

• #13

A simple vlookup will do it for you. Send me the details. I can do this.

 

pishty

Regular Member

Dec 17, 2012

220

68

• Oct 31, 2013

• #14

True, just one simple vlookup formula and you're done.