jondavis1987
Active Member
- Joined
- Dec 31, 2015
- Messages
- 443
- Office Version
- 2019
- Platform
- Windows
I have a worksheet that's a cost of materials worksheet. In the workbook are several different worksheets with different products that use different percentages of different materials. Is there a way to make the cost of materials worksheet update automatically to the information pulled from the worksheet i'm in?
For instance the worksheet with costs is just named "Costs". In "Costs" B20:B30 has a list of all material names. C20:C30 has current percentages of materials. D20:D30 has new percentages we are looking at. In worksheet named "S3pv0261800500" C2:H2 has matierals used in this product. C4:H4 has current percentages. C5:H5 has the new percentages.
But worksheet "S4pv0261600100" only has materials in C2:G2 with percentages in C4:G4 and new percentages in C5:G5.
As it is i would either have to create a cost sheet to go with each product, which would be tedious, or i have to manually type it into the "Costs" sheet. Was wondering if there's a better way?
For instance the worksheet with costs is just named "Costs". In "Costs" B20:B30 has a list of all material names. C20:C30 has current percentages of materials. D20:D30 has new percentages we are looking at. In worksheet named "S3pv0261800500" C2:H2 has matierals used in this product. C4:H4 has current percentages. C5:H5 has the new percentages.
But worksheet "S4pv0261600100" only has materials in C2:G2 with percentages in C4:G4 and new percentages in C5:G5.
As it is i would either have to create a cost sheet to go with each product, which would be tedious, or i have to manually type it into the "Costs" sheet. Was wondering if there's a better way?