copying data from one workbook to another
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?
|