use an userform as a filter to create an invoice

[DB73]

Hi peeps,

i've a question about how to populate texboxes based on comboboxes that i want too use as a fliter.

i have 1 sheet witch if populate via an userform
i put all my working hours in based on a date
that "dumpstats"sheet" has coloms beginning with date, project, projectnr, normal working hours, overtime hours, rate.
so, for 1 day i can have several rows with different projects and or woring hours.

now i'm trying to make a new userform with comboxes that i want to use as a filters.
i started too make the userform with some comboxes as "year', "period",'"project", "Projectnumber".
maybe i have too add some more, but its just a start.

now, i can populate a textbox from a combox input....but....
i want too populate the textbox(es) with data from the "dumpstats"sheet with a lookup function based on the comboxes that i want too use as a filter.

for example
textbox1 needs to populated with the sum of all "normal" working hours (over 1 week of period)
textbox2 needs to be populated with the sum of all "overtime' hours". (over 1 week of period)
etc..
see attachment

then the text/value of the textboxes have to to my invoice sheet ( got the code for that, i'm able to do that)

maybe not quite clear due to my poor english, if not clear, please ask.

thanks in advance

 

[DB73]

 

[DB73]