| Oops sorry, please forgive my inexperience with Excel, I know what I mean and assume every one else does too. lol.|
Many thanks for replying DerbyDad03.
From the 880 rows of data in the range, let's say 7 are counted by the SUMPRODUCT function as satisfying the criteria specified in the formula.
The number '7' is returned to the same cell in which the SUMPRODUCT function is found in Sheet 2.
Is there a way at all for excel to then copy those 7 rows only into a list on Sheet 2 below the cell which displays the number 7?
I appreciate that my knowledge of the application (whilst increasing slowly) is very limited and there may be a far better method to examine the rows I need from the main range and copy them. It's just that it was quite a personal achievement to formulate the SUMPRODUCT function to accurately count the specified rows, now I need those rows to be copied into a new list on a different sheet of the same workbook.
I hope this explains my query, thank you for considering the question.