Extracting and transferring data across sheets

Hi,
I'm trying to write the code to get certain rows of data on one sheet to transfer to another sheet. The data sheet is denoted "Sheet1" and the compiled sheet is denoted "Sheet2". The compiled sheet has one row of input that includes values as well as 8 categories/classifications. If all of those 8 categories match an entry in the data sheet, then the entire row will be transferred to the compiled sheet. All of the data fields match up in each sheet; that is, the qualifications are in columns 19-26 in both. The rows to be transferred will include columns 2-26, and will go into the second sheet starting at row 3.
I'm using nested looping structures to do this, and what I have seems as if it'll make sense, but when I go to run it, there is a type mismatch. The part that gets highlighted is at the very beginning: Private Sub Transfer()
What am I doing wrong?

-------------------------------------------------------

Please Login or Register  to view this content.

I have not checked if your code does what its supposed to, but i have corrected it so it shouldnt give you any errors. Try this

Please Login or Register  to view this content.

Are you still getting the error? Check if your sheets are named as "Sheet1" and "Sheet2" as per the code.

Can you upload the file you are using with the macro? Remove any sensitive data.

I click on Enter data button on sheet2 and got the form. I filled it up and the data came into Sheet2.

Now i didnt see any button called "Transfer" to move the data to Sheet1. How is that code triggered?

Also, you need to place that code in a module and not in the "ThisWorkbook" section.

Ok..did you try running the macro after putting it in the module? Did you get any error? If you got an error, when you clicked on debug, which line of code was highlighted?

Change it to

Please Login or Register  to view this content.

Is your sheet named "Sheet1"?

If yes and it still does not work try this

Please Login or Register  to view this content.

Can you attach the file that you are using? Remove the sensitive data.

I made some more corrections to your code. Run it and see if it gives you what you need.

Please Login or Register  to view this content.

The Private Sub CommandButton3_Click() you see is for the Transfer button. Its named as CommandButton3 in the backend.

Yeah i noticed that but didnt know in what format you want the output, so i didnt change anything.