I need to create a macro in excel to search through a column of numbers within a data report. First it copies and pastes the first three rows into another sheet. I then have 5 or 6 numbers that need to be individually found and have their entire row copied, as well as the two rows under the number. Then the three copied rows need to be pasted in another sheet. The macro needs to be set up so that if a number is not found, or is found and copy/pasted, it looks for the next number.

This is what I currently have with three of my chosen numbers to find:

Please Login or Register  to view this content.
I appreciate any assistance!

Moderator Note:

Pls use code tags around your code next time as per forum rules.