twedgewood
New Member
- Joined
- Jun 4, 2015
- Messages
- 4
I work for a limestone mill and we track production with Excel. See image below.
Above is the master Control List for the job. We separate it into trucks by tabs. So example we will go by the ripped column. Part number A2 has 4 total pieces for the job. Truck 1 might have 1, Truck 2 might have 3 on it. I need to be able to add production to the master list and excel automatically take the numbers and place them into the appropriate trucks. So if I only have 3 of part # A2 ripped, it should show 1 ripped in truck 1 and 2 ripped in truck 2. Make sense? If not I can clarify, just need some help organizing this.
Above is the master Control List for the job. We separate it into trucks by tabs. So example we will go by the ripped column. Part number A2 has 4 total pieces for the job. Truck 1 might have 1, Truck 2 might have 3 on it. I need to be able to add production to the master list and excel automatically take the numbers and place them into the appropriate trucks. So if I only have 3 of part # A2 ripped, it should show 1 ripped in truck 1 and 2 ripped in truck 2. Make sense? If not I can clarify, just need some help organizing this.