Transfering Data From Userform To Sheet Under Relevant Column And Row

[paul_pearson]

I`ve changed the layout to the data capture sheet.I have set up the sheet so data goes down the sheet for each set.With the userform can it look for the heading for the set and place the information going down the sheet.If I select C2 in the Userform Lenticular set then it places that info into C2 data capture sheet

Thanks

Paul