select range as in the first range without using scroll bar based on combobox on form

Hello
I have many ranges in H:L . the combobox is matched with names when I select the name from combobox1 I would search for the name in column I then the range should show as is in first range without using scroll bar to see the range is selected by combobox where is it .
as in the picture should move the range above when select name in combobox and populate the TOTAL row in textbox1.2.3.4.
thanks