Oct 06 2021 12:15 AM
Hello everyone,
I was creating a costing sheet for my small business and want some help related to it.
I'm attaching a sample file for reference.
The prices of raw materials used in our products change on a daily basis. So, I want to create a date-wise database of the costing of our products.
When I update the prices in the "Raw Material" sheet, the costing of finished products is automatically updated in the "costing" sheet.
Now I want to store this updated cost on a daily basis in the "data" worksheet automatically.
Can anyone help me with this?
Thank you.
Oct 06 2021 01:15 AM
@Ashu2405 The file you attached is just an empty sheet, Try again!
Oct 06 2021 01:34 AM
@Riny_van_Eekelen here is the file
Oct 06 2021 03:12 AM
@Ashu2405 Attached a very quick-and-dirty Power Pivot. Far from perfect, but perhaps it can help you establish a working system in your real situation.