Transfer data between two excel files

speedyd

New Member
Joined
Mar 4, 2004
Messages
5
I have two excel files (zip file and ship file) that I want to combine into one. The zip file contains a list of zip codes and the sequence numbers associated with each zip code (zip code in one column, sequence number in another column). The ship file contains a list of sequence numbers and the address associated with each number.

I would like to combine both files so that it shows a list that contains the zip code, sequence number and the address in three different columns.

Any ideas??

Thanks,
SpeedyD
(y)
[/list]
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
how about a vlookup on the second workbook to obtain data, then copy/paste special values to *hardcode* it in there.

then you can get rid of the first workbook altogether.

that is if there's no duplicates, else anotherfunction may work better.

edit: welcome to the board! (didn't notice it was your first post!)
 

TradBum

New Member
Joined
Mar 4, 2004
Messages
15
Welcome to the Board!

If the sequence numbers are the same, you can use VLOOKUP.

The help file gives a detailed explanation.

If that won't do it, the use Colo's HTML Maker (you'll find the link at the bottom of the page) to post a representative shot of each sheet.

Hope that helps,

Smitty
 

speedyd

New Member
Joined
Mar 4, 2004
Messages
5
Thanks Zack! However, there are duplicates in there because some of the zip codes are linked to the same sequence numbers. Would the vlookup still work? If so, how would I go about performing that function. This is new to me so any help is appreciated.

Thanks,
D
 

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web

ADVERTISEMENT

try posting some data as Smitty suggested w/ Colo's HTML Maker (link at bottom of this page \/ ), we could probably work something out :)
 

speedyd

New Member
Joined
Mar 4, 2004
Messages
5
I tried to download the 4.2 version and it doesn't seem to be working. Is there something else I need to do?
 

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
did you?...

download to your pc?
unzip to c:\windows\addins? *or other suitable folder*
in excel, click Tools -> Addins -> Browse -> file (from folder)?

if so, do you see a "Html" on your toolbar?

if not, have you tried the earlier versions?

how about:
Tools -> Macros -> Security -> Trusted Sources (tab),
is the trust add-ins checked?
how about the access to vb projects?
check those two.

post back w/ problems.
 

TradBum

New Member
Joined
Mar 4, 2004
Messages
15
What's not working with it?

If you just opened it from the zip file, you should now have an HTML Menu. If you put it in your Add-Ins folder, you'll need to activate it. Tool-->Add-Ins-->HTMLMaker 2.42.

Once activated, goto HTML-->Select Used Range (You can adjust as necessary with Shift+Arrow). Follow the prompts and an image of your sheet will open in a new browser window. There's a button at the bottom to send the image to the clipboard. Click it. Then return to your Mr.Excel post and CTRL+V to paste the HTML code into the post.

Smitty
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,563
Messages
5,765,119
Members
425,262
Latest member
sabry

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top