VBA filter with userform comboboxes

Originally Posted by koffer

Hi, I'm new to VBA and got this task to do.

I have a table, columns A to G with nearly 100 rows on eash.
What I'm trying to do is by choosing from combobox1 in a UserForm,
combobox1 will give alternatives from columnA ("W19" or "W20") to choose from, combobox2 will give alternatives from columnB (ex, "I" , "II" or "III" depending on if they are matching the choise from combobox1), and combobox3 will give alternatives from columnC (ex, "ASD" , "ZXC", "FGH" or "QWE" depending on if they are matching the choise from combobox2).

when these alternatives are chosen I would like all results (entire rows) that have these criterias, to be copied and pasted to sheet(results)

see attachment to understand

anyone who can help me? thankful for answers

I made a new attachment for better understanding!

nevermind, got it to work.