PLCdeveloper
Technical User
Using Excel 2000:
I have a "master" spreadsheet that contains Part Numbers and their associated data. The PN's are all in collumn A, and the data that corresponds with the PN's reads across (3 additional collumns of data).
I want to start a 2nd spreadsheet that allows me to type in Part Numbers in collumn A; and would like this sheet to fill in the corrresponding product data from the 1st sheet.
Example: Master sheet looks like this:
PartNumber Price Location Avail
12345 1.00 Denver Yes
12350 1.50 Dallas Yes
12360 2.00 New York Yes
12370 3.00 Portland No
On the 2nd worksheet, I would like to type in the PN in collumn A, and have the spreadsheet "grab" the corresponding data from the master spreadsheet. If I enter:
12350 then col B, C, and D should be filled in:
12350 2.00 New York No
Sorry I'm such a rookie as MSOffice but I have been working on this using Get External Data for awhile and think I may be missing the forest for the trees. Thanks in advance...
I have a "master" spreadsheet that contains Part Numbers and their associated data. The PN's are all in collumn A, and the data that corresponds with the PN's reads across (3 additional collumns of data).
I want to start a 2nd spreadsheet that allows me to type in Part Numbers in collumn A; and would like this sheet to fill in the corrresponding product data from the 1st sheet.
Example: Master sheet looks like this:
PartNumber Price Location Avail
12345 1.00 Denver Yes
12350 1.50 Dallas Yes
12360 2.00 New York Yes
12370 3.00 Portland No
On the 2nd worksheet, I would like to type in the PN in collumn A, and have the spreadsheet "grab" the corresponding data from the master spreadsheet. If I enter:
12350 then col B, C, and D should be filled in:
12350 2.00 New York No
Sorry I'm such a rookie as MSOffice but I have been working on this using Get External Data for awhile and think I may be missing the forest for the trees. Thanks in advance...