Hi
I need to populate data for column A,B and the column contains date in header with match selected date from combobox1
the column date will contains numeric values.
and if combobox2 contains two conditions (not zero, zero)
when select date from combobox1 will populate data after matching the date is in header in row1 and when select not zero from combobox2 then will populate data except containing zero or empty in column(3) in listbox . when select date from combobox1 will populate data after matching the date is in header in row1 , when select zero from combobox2 then will populate data except containing not zero in column(3) in listbox . when select date from combobox1 will populate data after matching the date is in header in row1
the populate data on userform
first when just select combobox1 should populate all of numeric numbers also zero and empty cells as in image1.
second depends on select combobox1 ,case from combobox2(NOT ZERO) as in image2
third depends on select combobox1 ,case from combobox2(ZERO) as in image3
also cross posted here with a little different
https://www.mrexcel.com/board/thread...bobox.1255108/
Bookmarks