Importing data to column from column with differnet names

B

bey12

I am using a shopping cart that exports order data to a csv file. I
contains the usual order data (customer, purchase, billing, product
shipping info). I need to import that data into a different xls fil
that my fulfillment company provides so that they can process th
orders on a daily basis. They then return the information back (i
shipping status & tracking updates)

The two files have the same information, but because they are
different companies, the column headers (fields) are completel
different.

I need to a way to automate the process of taking the data from th
shopping cart's csv output and mapping it to the fulfillment center'
csv file. I have no idea of how to approach this since I am an exce
newbie? Is it macros, vb or something incredibly simple?

I am attaching the 2 files (output from shopping cart, sample xls fro
fulfillment company) in a zip.

:confused

+-------------------------------------------------------------------
|Filename: import-map-fields.zip
|Download: http://www.excelforum.com/attachment.php?postid=5141
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

data=>convert text to column 7
Importing Data from a pre-existing spreadsheet 2
Importing data. Problem with datatype in column 2
Make first imported CSV row into column names ? 3
Lift Data from Rows to Populate HTML Variables 1
How to import and export data? 1
How to group all data from 1 column into several columns 2
Importing data from one worksheet to another? 4

Top