Userform Data Entry on multiple sheets

[Rthigpen162]

Hello, this is my first post and I am very new to VBA.

I am trying to make an excel sheet to track production for manufacturing.

I am trying to create a userform that will input operator supplied data (# of parts completed per day) into the correct spot on each sheet for each job we are doing. My current thought process is that I want the Job # combo box to designate which sheet the store the data, then the shift number to specify which column (C, D, or E), then day number to specify which row (3 through 33) and ultimately lock the cell for further editing after the data has been put in rather than allowing for the program to overwrite the cells. Would this be the best way of going about this?

As of right now I have the userform designed and the combo boxes linked to charts to populate their selections as well as the userform.show function connected to a command button.

Any help would be greatly appreciated!!

 

[ranman256]

the data should be entered into a straight-forward list
JOB#, Date, Shift, PartComplete

this allows you to run analysis on the data (pivot or other) and put it into your special sheet you show.

 

[Rthigpen162]

Do you mean that I should have the user data go into a simple form where I can then send it to my desired sheets?

Thanks for the reply

the data should be entered into a straight-forward list
JOB#, Date, Shift, PartComplete

this allows you to run analysis on the data (pivot or other) and put it into your special sheet you show.