Good evening everyone,
I would need help in this, tried to search but not getting what I need.
I have a Cmd button on my Sheet1 that does the following:
Private Sub CommandButton1_Click()
UserForm1.Show
End Sub
My userform1 is a listbox1 that has info from my sheet2 in Cells A3 to A1000.
In my Sheet2 I have DataForm that is from column A to column N.
I need that when I select my cmd button from sheet1 to open the userform1 (listbox1) that when I double click on a selection to search in my Sheet2 vs the row that matches the title and to copy that selection (so from A to N on sheet2) then to copy and paste the information (by transposing itself) in sheet1 A7.
I also need help if I select multiple selection from the UserForm1 (listbox) to skip a row when the second batch of information is copied and pasted.
I have attached my workbook with better explanation.
Please help thank you.
Integrity Check.xlsm
Bookmarks