Match data from columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ny17776 - 14 Dec 2005 14:59 GMT

I am looking to import data from another spreadsheet to a master
spreadsheet. The common thread between the two is a serial number. I
want to match the serial numbers and the associated data from the newer
spreadsheet to the master spreadsheet's list of serial numbers. The
larger sheet contains roughly 900 serial wheras the smaller only has
information for 170 of those. I want to import and then somehow mach
the colums based on that serial number. Is there a way to do that?

Signature

ny17776

Reply to this Message

Peo Sjoblom - 14 Dec 2005 15:13 GMT

Use one these methods (tagging or highlighting) and use the serial as
criteria

http://www.cpearson.com/excel/duplicat.htm

Signature

Regards,

Peo Sjoblom

> I am looking to import data from another spreadsheet to a master
> spreadsheet. The common thread between the two is a serial number. I
[quoted text clipped - 3 lines]
> information for 170 of those. I want to import and then somehow mach
> the colums based on that serial number. Is there a way to do that?

Reply to this Message