Hello,
I am wondering if any Excel brains out there can help me with a simple dashboard/recording system I am looking to implement for our production team.
To give some background, we are a company that manufactures rubber mats, and we are looking for a dashboard to give the production team some incentive and allow them to track their production output.
I have attached an Excel spreadsheed that I am working on. Essentially, each day of the week, we keep a record of the times in which a new cycle begins. Each cycle represents the production of 8 mats.
What I want to do is have a “Start New Cycle” button programmed on the dashboard tab to run a macro. Ideally, when the button is pressed, it would record the current time into the next available cycle number for the day. That would then update the number of mats produced, and then it would reset the cycle time, and affect the countdown clock. Then, at the end of the week, the document should record the number of mats produced for the week on the Historic Data Tab.
I am looking for some help on how to run the macro, and have it so that the dates update automatically rather than manually keying in the date each week.
Can anyone please assist? I am more than happy to connect to provide further information if needed.
Thanks,
Yorke Graham
Bookmarks