How do I automatically create lists from column topics in a chart

Joined
Jun 22, 2015
Messages
1
Reaction score
0
We have a chart to fill out daily about our hourly production which includes our hourly pitch, our actual pitch for the hour, a list of all the stations so we know exactly how many parts were lost there due to production downtime, scrap, and three other columns that would be the reason as to why we didn't make the hour (start up, cycle time, other), overproduction if we did over produce, and a column for comments as to noting when and why we were down or if something happened at that particular hour. Based on these columm headings, how do I connect this chart to auto populate in another sheet to automatically make a list based on my chart? I need to make lists of each seperate station and their down times and when, a list of scrap that we get and which kind of scrap, etc. This also has to be accessible to whomever and it will be updated daily so I also need new information entered to show up in the appropriate list according to conditions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top