Hi all, I am not proficient in excel in the slightest, but I am tasked with setting up a production schedule for our company. The schedule will consist of a sheet for each production line and I will be manually inputting the number of pieces everyday. What I need the sheet to do is to add the pieces together until it hits 8000. 8000 represents the quota for the production line that day, so if they are mid job, the remaining quantity will need carry over to Tuesday(in this case cell E3). The number of items per day will vary(sometimes up to 20 different items as all these kits are custom built)I have attached the rough draft of my sheet I'm putting together and not making any headway. Maybe there is a production schedule out there similar to what I'm needing. I'm open to options. If not, what can I do to achieve my goal of completing this? I'm open to purchasing templates if necessary.
A production schedule
- Thread starter cmcz450
- Start date
p45cal
Well-Known Member
In the attached:
which you can change to:
Across = True
which will alter the output so that separate days are put into new columns to the right (akin to your original attachment).
- At cell A1 a table containing your production requirements. This table must be at cell A1. The table must be a proper Excel table (not just columns of data).
- A button at cell C2 which runs the macro blah. This macro runs on whichever sheet is the active sheet at the time the button is pressed. You'll see on the second sheet that there's another table and another button calling the same blah macro. You can add a table on any sheet and add a button calling blah, the macro will operate on any table as long as it includes cell A1.
- As I've left it, the output is just 3 columns wide and as long as it needs to be.
- The macro does NOT delete anything on the sheet before overwriting what might be there; I leave it up to you to clear the necessary area on the sheet before running the macro (pressing the button).
- Make sure any real data you enter is covered by the extents of the table at cell A1. As I've left it the table only extends to row 7 (your original data). At the bottom right of cell B7 you'll see a little drag handle which you can drag down/up to change the extents of the table. This will affect what the macro works on. Often, the table will change its own size as you add/remove rows of data at the bottom.
- In the macro itself there's a line (the first line):
which you can change to:
Across = True
which will alter the output so that separate days are put into new columns to the right (akin to your original attachment).
- There are other comments in the code.