Open two text file in Excel

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Hi,

How could I open or merge two text file in excel, I am
trying to create a macro that would join my two text in
excel. Something like this:

File1 Contains my header:
Name
Company Name
Address
City

File2 Contains my data:
Joe Peter,ABC Company, 123 1st Street, Unicity
John Does, MyCompany, 345 22nd Street, City
..
..
.. and soon.

I want to put Name on top of Joe Peter, Company Name on
top of ABC Company, and soos

How could I do this?

Thanks for your help.
Eric
 
Open the first, select the header data, do copy, then do paste special
transpose onto a master sheet.

opne the second file, copy the data and paste below the transposed header on
the master sheet.

Turn on the macro recorder, then do it manually. This will give you the
basic code you need - you can then generalize it.
 
Back
Top