I have 2 sheets in one workbook. #1 contains an order form, #2 contains a filtered list of goods.
Filtering is available by 9 criterias, so the list has 9 columns.
I want want to tranfer somehow selected row of filtered list to sheets #1 exact location.
I prefer to use combo box in sheet #1, but don't know how to make it work.
How should I get a right filtering if I use 9 different combo boxes in sheet #1.

Maybe there is another way to solve this problem?

Thanks in advance.