match items and copy the entire row to a new worksheet

[Gordonhk]

I have 2 worksheet with different contents but 2 of the worksheets have same unique IDs in Column A in Worksheet "Database" and in Column B in Worksheet "Sheet2". I want the vba code to find that particular ID from Worksheet "Sheet 2" and worksheet "Database" and copy me the entire row from Worksheet("database") to a new worksheet "Sheet1". Below is the code but the row which is copying is not correct.

Please Login or Register  to view this content.

Can you please help me?

[AB33]

Please attach a sample

[JasperD]

Hi GordonHK,

please try this :

Please Login or Register  to view this content.

Please click the * below if this helps

[Gordonhk]

OMG works perfectly... Thanks JasperD