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

Extract data in rows (with line breaks) to form a table 0
Adding data to MS Access from csv file 0
importing images into Excel Collumn 0
How to Write EXCEL files from a FORTRAN Program ? 0
Merge excel files with different column headings 1
Consolidation Table from Different Excel Tabs with Different Format 1
Remove Data which is not match with other column 1
CSV file conversion + True/False over multiple columns of data 1

Top