Matching data from two colums on separate sheets, and copying rows of matches to sheet 3

[jukurit]

I have information on two sheets. Sheets 1 and 2. I need to mach the data in sheet 1 column C with data in sheet 2 column P. If the numbers match i need the row in sheet 2 that has the matching number to be copied into sheet 3. (there are multiple numbers that match in sheet 2 and i set by sheet 1)
Suggestions please?

 

[jukurit]

it said cant execute code on break mode for this line

sh.Cells(Rows.Count, 16).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlValues

 

[JackDanIce]

Try changing it to:

sh.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlValues

Although this was suggested before. I think there's something in your layout that you're unaware of that is causing the problem.

 

[jukurit]

yeah probably. cause now its pasting the rows over eachother on the same row.

leaving only the last one visible

 

[JackDanIce]

In Sheets("Yhteyshenkilo") does every row in column A contain a value? I.e. is every row in column A non-blank?

 

[jukurit]

THANKS MAN!!!
that was the problem.

awesome. saved me alot of time!

 

[JackDanIce]

You're welcome