Create a macro in excel

[Newatprogramming]

I am trying to create a macro that could from a list of numbers in a column, be able to find all matching numbers in the first column from another worksheet, extract the row into another worksheet. For example:

( WORKSHEET 1 )
( find these numbers in the first column of worksheet 2, and copy the whole row to worksheet 3.

2222
2333
2323
2313


(WORKSHEET 2)

2221 12/23
2222 12/22
2223 12/22

2322 12/22
2323 12/22
2324 12/22


(WORKSHEET 3)

2222 12/22
2323 12/22

 

[Foada]

Is the data all continuous down the columns? How are you looking to initiate the macro? Command Button? Worksheet Active? If you choose to battle wits with the witless be prepared to lose.