copy data from userform to empty row based on combobox

norie , yes the general structure should be

royUK thanks , yes you told me but my report contains many classification into many brands and many brands classifications contains many items so I have to fill the data in one sheet , about my file is a sample that's why you said no need vba , but my real file needs it