I have 2 Spreadsheets. I want to copy the value from 1 cell into another sheet but I have multiple lines with the data in 1 sheet but only 1 line of the same data in another in another. Sheets below:
So I want to replace L2:L7 in the Master Asset File with I2 from Purch Orders. The PO NO (4) is a common denominator but I could have more than 1 desc with the same PO. So I need to look at the PO No and match the Text Col in Master Asset File with Part No & Details from the onther sheet.
Any ideas..??????
Purch Orders BP²I.xls | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | PSPONo | LineNo | Company | PartNo | Details | Qty | UnitCost(GBP) | Expense/Asset | AssetValue | ||
2 | 4 | Repton | 292889-421 | ProLiantDL360(G3)R02XeonDP2.8GHz,512MB | 2,217 | ||||||
3 | 4 | Repton | 292892-B21 | XeonDP2800/512-533ProcessorOptionKit | |||||||
4 | 4 | Repton | 300678-B21 | 512MB(266MHz)DDRPC2100RegisteredECCSDRAM | |||||||
5 | 4 | Repton | 286714-B22 | 72.8GB(10000rpm)PluggableHardDiskDrive | |||||||
6 | 4 | Repton | 293703-B21 | DL380G3HotPlugRedundantPowerSupply | |||||||
7 | 4 | Repton | 263825-B21 | IntegratedLights-OutAdvancePack | |||||||
8 | 4 | Repton | 331903-B21 | SlimlineDVD-ROM/CD-RWComboOptionKit | |||||||
9 | 4 | Repton | BUILD | inhousebuildandtest | |||||||
10 | 4 | Repton | DEL-NEXT | delivery | |||||||
11 | 8 | Repton | 325134-421 | ProLiantDL580(G2)R02Xeon | 13,555 | ||||||
Assets |
Master Asset File.xls | |||||||
---|---|---|---|---|---|---|---|
K | L | M | N | O | |||
1 | Text | AcquisitionCost | AccDpen | NBV | PONo | ||
2 | 292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB | 2,055.00 | 2,055.00 | 4 | |||
3 | 292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB | 2,055.00 | 2,055.00 | 4 | |||
4 | 292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB | 2,055.00 | 2,055.00 | 4 | |||
5 | 292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB | 2,055.00 | 2,055.00 | 4 | |||
6 | 292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB | 2,055.00 | 2,055.00 | 4 | |||
7 | 292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB | 2,055.00 | 2,055.00 | 4 | |||
8 | 325134-421ProLiantDL580(G2)R02Xeon | 10,055.00 | 10,055.00 | 8 | |||
BP²I Assets |
So I want to replace L2:L7 in the Master Asset File with I2 from Purch Orders. The PO NO (4) is a common denominator but I could have more than 1 desc with the same PO. So I need to look at the PO No and match the Text Col in Master Asset File with Part No & Details from the onther sheet.
Any ideas..??????