Hello!
I'm a department manager at a manufacturing plant and I've been working on an hourly performance management spreadsheet to track operator production versus standards. Each product has a different run speed (i.e. Cereal Box @ 20,000 units per hour). I've gone so far as to list each product and create a drop down list using the data validation feature. My goal is to automatically populate the standard speed cell based on what product is selected from the drop down list. Any ideas?
Thanks!
Bookmarks