I don’t know what to call it so I can’t research what I am trying to do!

My company uses a sheet that gets printed to allow the machine operators to record their daily totals. I want to use the same sheet to automatically fill in the data I enter to different sheets. Like a form, but not the “form” function. Basiclaly we keep track of parts made by MACHINE. Each machine has its own worksheet in the workbook. There are about 100. Then each days count gets entered by me into each machines sheet by date. Can I make a “form” and tell it to send that info to the correct corresponding cell on a another sheet? Easily I mean. I don’t want to have to formulate 3650 lines. The biggest thing getting it to enter the data depending on the date I record on the “form”. I know this can probably be doen but I don’t know what it is called so I can’t research how to do it. 

By: Heather

Leave a Reply

Your email address will not be published. Required fields are marked *