userform help with code for combobox4

[s_g]

Hi

The Userform works perfectly but now I have just added Combobox4 to the userform.I never sent to 2 sheets with the single userform so not sure it is even possible....Currently all data is sent to either sheet Unit 1 or Unit 2 or Unit 3....what code do I need to add so that when a selection is made in Combobox4 it looks at both the Date,Unit and Shift and then sends this number to matching criteria....example...If the date in Userform is 7-1-2014,Unit A and Shift as Afternoon then it will send only Combobox4 to "Unit A Performance" C19 and the rest of data goes to sheet "Unit A"
..example...If the date in Userform is 7-1-2014,Unit C and Shift as Night then it will send only Combobox4 to "Unit C Performance" C35 and the rest of data goes to sheet "Unit C"

Thank you

[Admin]

Hi

Question.. why do you need to keep the data in separate sheets ? It'll always good to keep the data in single tab whihc is easy to maintain at the same time creating reports from the data.

So I would suggest you to add 3 more columns, one for Unit, second one for shift and third one for hours.

[s_g]

Thank you for reply
Different sheets will look for different data...I do not require the hours in the Unit sheets but do in the Performance sheets....there is much more data to enter....

[s_g]

Is it possible to have userform to send data in combobox4 to other sheet?
Are you able to write code to achieve
I may also look at your suggestion of data in 1 sheet

Thanks