D
Danno
Good day. I am using Excel 2002 on Windows XP. I have several workbooks
controlling the production in my ice cream store.
1. Item Price List - stores the cost of each component used in a product
with data supplied from Quickbooks. This workbook also calculates the cost
per ounce or pound since Quickbooks cannot do this.
2. Product Cost - calculates the cost of each product sold by listing the
components of the product and using VLOOKUP to find the price from the Item
Price List. One workbook per product.
3. Master Price List - calculates the sales price of each product using
data from the Product Cost workbook. Assembles all of the products sold in
one worksheet.
The problem is this: When I open the Master Price List and look at the cost
of each product, it appears to be finding an old data. If I then open the
particular Product Cost worksheet and confirm the current cost, the price
then changes in the Master Price List.
I currently have over 100 products that I sell in the store, each one having
its own Product Cost workbook. I have examined the Links and all appear to
be correct. Is there something I am missing? Is there an update function
that I am missing? When I opened the Master Price List, it asked if I wanted
to Update the values, I answered Yes. Even if I exit and restart Excel and
answer Yes to Update again, the same old values are shown.
If more details are needed, I will gladly supply via email.
Thanks in advance, Danno...
controlling the production in my ice cream store.
1. Item Price List - stores the cost of each component used in a product
with data supplied from Quickbooks. This workbook also calculates the cost
per ounce or pound since Quickbooks cannot do this.
2. Product Cost - calculates the cost of each product sold by listing the
components of the product and using VLOOKUP to find the price from the Item
Price List. One workbook per product.
3. Master Price List - calculates the sales price of each product using
data from the Product Cost workbook. Assembles all of the products sold in
one worksheet.
The problem is this: When I open the Master Price List and look at the cost
of each product, it appears to be finding an old data. If I then open the
particular Product Cost worksheet and confirm the current cost, the price
then changes in the Master Price List.
I currently have over 100 products that I sell in the store, each one having
its own Product Cost workbook. I have examined the Links and all appear to
be correct. Is there something I am missing? Is there an update function
that I am missing? When I opened the Master Price List, it asked if I wanted
to Update the values, I answered Yes. Even if I exit and restart Excel and
answer Yes to Update again, the same old values are shown.
If more details are needed, I will gladly supply via email.
Thanks in advance, Danno...