Home » Forums » Open Source Learning Center » Question and Answer

import from one table to another

Submitted by jungle juice on 12 October, 2012 - 17:10

I have an Excel book 1 with 1000 items (row), it contains column A: item#, column B: manufacture, and column C: prices. Another Excel book 2 contains 500 items, this table has column A: item# (some are in book 1, some are not), column B: description

I created a new description column D in book 1, how do I import the description from book 2 to book 1, and have them auto match import to the correct item number without affecting book 1 items that are not on book 2? Also to let me know which items from book 2 that is not in book 1.

‹ need to develop a macro that can copy data to another sheet, perform calculations Need a correct formula ›
»
Nick's picture

have a look at

Submitted by Nick on 12 October, 2012 - 17:36.

have a look at this:
http://excelexperts.com/Excel-Tips-VLOOKUP-INDEX-MATCH%20

.. however, on a higher level, if one sheet is a view on data in another sheet, the best way to do this is to store the master data in one place, and use a pivot table to display the subset of the data, thus removing the need to reconcile between the 2...

»