Automatically create a date wise database

[Ashu2405]

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.

[#2]

@Ashu2405 The file you attached is just an empty sheet, Try again!

[#3]

@Riny_van_Eekelen here is the file

[#4]

@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.