Redness86
11-04-2006, 07:49 AM
Hello all,
I have two workbooks in Excel 2000. Source.xls has multiple sheets and stores price lists for products/services provided (no duplicate data). Target.xls has multiple sheets and is where we create cost estimates for numerous job sites for a single client (potentially a lot of duplicate data). As I update the cost of an item in Source.xls, I'd like that change to be reflected anywhere the item is found in Target.xls.
The sheets in both workbooks have the following setup:
ColA = Qty
ColB = PartNumber
ColC = PartDescription
ColD = UnitMeasurement
ColE = UnitMaterialCost
ColF = UnitLaborCost
ColG = UnitEquipCost
ColH = ExtMaterialCost
ColI = ExtLabor Cost
ColJ = ExtEquipCost
The criteria used to find matching items will be in columns B and C. Updates will be made in columns E-G, and Target.xls will be open.
I thought I'd found the answer in Silver Fox's posting, Updating multiple worksheets at once; four source, three target, but I couldn't get it to update the separate workbook. Any help would be greatly appreciated, thank you.
And thanks to everyone for all the other solutions I've found in this forum!
...
I have two workbooks in Excel 2000. Source.xls has multiple sheets and stores price lists for products/services provided (no duplicate data). Target.xls has multiple sheets and is where we create cost estimates for numerous job sites for a single client (potentially a lot of duplicate data). As I update the cost of an item in Source.xls, I'd like that change to be reflected anywhere the item is found in Target.xls.
The sheets in both workbooks have the following setup:
ColA = Qty
ColB = PartNumber
ColC = PartDescription
ColD = UnitMeasurement
ColE = UnitMaterialCost
ColF = UnitLaborCost
ColG = UnitEquipCost
ColH = ExtMaterialCost
ColI = ExtLabor Cost
ColJ = ExtEquipCost
The criteria used to find matching items will be in columns B and C. Updates will be made in columns E-G, and Target.xls will be open.
I thought I'd found the answer in Silver Fox's posting, Updating multiple worksheets at once; four source, three target, but I couldn't get it to update the separate workbook. Any help would be greatly appreciated, thank you.
And thanks to everyone for all the other solutions I've found in this forum!
...