Automatically create a date wise database

%3CLINGO-SUB%20id%3D%22lingo-sub-2816151%22%20slang%3D%22en-US%22%3EAutomatically%20create%20a%20date%20wise%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2816151%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3EI%20was%20creating%20a%20costing%20sheet%20for%20my%20small%20business%20and%20want%20some%20help%20related%20to%20it.%3C%2FP%3E%3CP%3EI'm%20attaching%20a%20sample%20file%20for%20reference.%3C%2FP%3E%3CP%3EThe%20prices%20of%20raw%20materials%20used%20in%20our%20products%20change%20on%20a%20daily%20basis.%20So%2C%20I%20want%20to%20create%20a%20date-wise%20database%20of%20the%20costing%20of%20our%20products.%3C%2FP%3E%3CP%3EWhen%20I%20update%20the%20prices%20in%20the%20%22Raw%20Material%22%20sheet%2C%20the%20costing%20of%20finished%20products%20is%20automatically%20updated%20in%20the%20%22costing%22%20sheet.%3C%2FP%3E%3CP%3ENow%20I%20want%20to%20store%20this%20updated%20cost%20on%20a%20daily%20basis%20in%20the%20%22data%22%20worksheet%20automatically.%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%20with%20this%3F%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2816151%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2816313%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20create%20a%20date%20wise%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2816313%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1176656%22%20target%3D%22_blank%22%3E%40Ashu2405%3C%2FA%3E%26nbsp%3BThe%20file%20you%20attached%20is%20just%20an%20empty%20sheet%2C%20Try%20again!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

3 Replies

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

@Riny_van_Eekelen here is the file

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