copying data from one workbook to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I maintain a workbook containing packaging info (dimensions + weight) for
about 9000 items. If sizes are changed, I receive a spreadsheet from someone
else containing the updated data for a subset of those items. Is there a way
to compare item numbers (unique identifiers) and automatically copy over the
updated information?
 
Try using the "Vlookup" functionality in Excel. There are a lot more details
under the Help file in Excel...just type "Vlookup"

Hope that helps - I'm not an expert on it, but know that it exists.
 
Thanks for the suggestion. Unfortunately I don't think that will do it. What
I need is a function (probably a macro rather than a formula) that will look
at the item numbers in 2 workbooks. If an item # exists in both Book A and
Book B, and contains data for length, width and height in Book B, it will
overwrite that data to Book A. If the item number doesn't exist in Book B, or
there is no data for length, width or height, then it will not overwrite
those fields in Book A.

I suspect I'm going to have to move to Access to do this.
 
You must log in or register to reply here.

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

Migrate mailboxes from one Microsoft Exchange Server to another Exchange 1
Macro to push data to another workbook 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
mapping? columns from one excel workbook to another 1
What makes people want to buy this NetBook 2
Copying template from one worksheet to another 2
update data from one workbook to another 4
comparing values from one workbook with another workbook 3

Back
Top