Pattern matching and then copying PasteSpecial to another sheet

Hi am trying to figure out how to change the copy code to a copy pastespecial code. Any suggestions? Thanks for your help in advance!

HTML Code: 

hi hanott1, it can be done a bit differently without using loop. Please check attachment, press Copy.

Why do you need the pastespecial option for copying?

Thank you watersev... The data I copy has vlookup formulas from another sheet... I did not want to copy the formulas over into the testtab.

Problem SOLVED! Thank you so much for your quick response and time... I greatly appreciate it!