Production counter with history database

[a94andwi]

Hello.

We are trying to create a simple production counter which should count number of pcs produced and also measure how well we perform according to plan.
I need to create a History table that updates it self once a day at a specific time.
I have attached a file that explains what the macro should update.

Every morning at 05:41, add a new row to the history table and add date, planned parts, produces parts, and calculate backlog status.

More details in the attached file.

I really hope you can help me...

/Anders

[maniacb]

Try placing the following code in the workbook module:

Please Login or Register  to view this content.

And thiscode in a standard module

Please Login or Register  to view this content.

[a94andwi]

Hi.

the code does its job but there are something strange happening. I have made it a little bit easier for the "Updatehistory" function so that the calculation are done on the sheet instead and it only copies and writes the value from one cell (K13).
For some reason it writes the wrong value and it writes multiple rows.

Any ideas? I have attached a newer version of the file.

[maniacb]

To fix writing the correct value, I included code to prevent Automatic calculation while it runs. I do not see any duplicate lines being produced.

Please Login or Register  to view this content.

[a94andwi]

It seem to work better. We will work more with this and maybe I'll open the question again. for now I am very satisfied and kindly sends a big thanks!!