search that copies all matching rows to different work sheet.

[gherzberg]

I am new to VBA and cannot seem to find out how to create a code that will allow me to search for a specific term in one worksheet, that will copy all matching rows to another worksheet. Any suggestions?

[tigeravatar]

gherzberg,

Welcome to the forum!
Give this macro a try, here's what you'll need to adjust:
Change the strColSearch to the column that you'll be looking in
Change wsData to the sheet containing the data where you'll be searching
change wsDest to the sheet that the found information will be pasted to

Please Login or Register  to view this content.

[gherzberg]

thanks is there a way to add a text box at the top of the destination sheet rather than the user box prompt