Find word and if number appears below word then copy

Might need to change the sheet names in the code on the first two lines, you never really specified what the first sheet is named.

Please Login or Register  to view this content.

@Walruss That works BUT it doesn't take into account that there has to be a number found directly below the cell where D1 is found in column A before doing the copying and pasting. Once that has been added then it's perfect. Any idea how to add that clause?

@John - That works but if the first time it finds the word and it has no number below it then it stops. It needs to keep searching until it finds a number under the word, then stop looping.

Try the code I posted above

That works BUT it doesn't take into account that there has to be a number found directly below the cell where D1 is found in column A before doing the copying and pasting.

It does evaluate that at this line, which works on my test sheet:

Please Login or Register  to view this content.

If it's not working for you, can you post a sample data set where the evaluation fails?

Please Login or Register  to view this content.