Hi guys.
I need help because I try more things but without success. For example I have sheet1 where at row B1:FA1 are references numbers 6digits. From B2:FA50 are filled names or numbers also with 0 values. What I need is based on useform combobox1 reference value find column number at sheet1 from B1:FA1, select it and make autofilter at selected column for non zero values. These values I would like to copy to sheet2 range A2. Also refresh these values if I choose another reference at combobox. Any help? Thank you
I need help because I try more things but without success. For example I have sheet1 where at row B1:FA1 are references numbers 6digits. From B2:FA50 are filled names or numbers also with 0 values. What I need is based on useform combobox1 reference value find column number at sheet1 from B1:FA1, select it and make autofilter at selected column for non zero values. These values I would like to copy to sheet2 range A2. Also refresh these values if I choose another reference at combobox. Any help? Thank you
