tried and tried but sadly failed. changed my original plan but even that not working.

1) what I have is a "Main" workbook with a userform that has a listbox and 2 button. that listbox loads values from a "Question Database" workbook "Technical" worksheet, when a "load" button is clicked.
2) Then when "Accept" button clicked, all the 5 values of the listbox are copied to column F of the workbook that has the userform.
3) And.... what I want to do is: the same "Accept" button should loop and search for all the 5 values in column F of the "Main" workbook in "Question Database" "technical" worksheet and if found copy the entire row from the "Question Database" to a 3rd workbook called "Staff File" workbook "Technical" worksheet in the next available row.

Wondering how to get around with this too many workbooks I thot I'd first test it within the same workbook but different sheets. but even that is not working. My following code attempt is the same as part 1 mentioned above, i.e. to search for all values that are in "Sheet 1" column F of "Main' workbook in "Question Database" workbook, and then when found, copy the entire row (or atleast columns A:E) from "Question Database" worksheet "Technical" to "Sheet2" or the "Main" workbook

the code dies on the red line here.

Please Login or Register  to view this content.
I tweaked it a but to this but then it only copied the last found record of Column F and override and pasted it in row A1 of Sheet2 of Main workbook. which means only 1 i.e the last row being copied and rest all overridden.

Please Login or Register  to view this content.
as usual would appreciate all and any help