Hi,
What I want to do is this:
I have a list of stock items and codes (Stock sheet, in the attached). Next to this is a column for cost.
The stock items and codes will be manually entered. But the associated cost must be extracted from other data.
The other data will be produced by entering a continuous list of stock purchases (Purchases sheet, in the attached) which will use lists created from the data in columns A & B of the Stock sheet.
Then I inserted a pivot table to generate a weighted average cost price for the items from the Purchases sheet.(This is on Sheet3)
This average cost price is the value I want to insert into the Stock sheet under Cost (Column C).
The entire row opf information from the Stock sheet will then be used in other sheets I will create (Job cards / quotations, costings etc)
I think I need to use the GETPIVOTDATA function but I am lost as to how it works... have Googled a lot and I just get more confused.
Please help?
Thanks
What I want to do is this:
I have a list of stock items and codes (Stock sheet, in the attached). Next to this is a column for cost.
The stock items and codes will be manually entered. But the associated cost must be extracted from other data.
The other data will be produced by entering a continuous list of stock purchases (Purchases sheet, in the attached) which will use lists created from the data in columns A & B of the Stock sheet.
Then I inserted a pivot table to generate a weighted average cost price for the items from the Purchases sheet.(This is on Sheet3)
This average cost price is the value I want to insert into the Stock sheet under Cost (Column C).
The entire row opf information from the Stock sheet will then be used in other sheets I will create (Job cards / quotations, costings etc)
I think I need to use the GETPIVOTDATA function but I am lost as to how it works... have Googled a lot and I just get more confused.
Please help?
Thanks