Consider a single Column of up to 80 rows. Each row
shows a numeric (1 or 2) or text value ("Ladies"). I'm
trying to find the first "n" values of each (say 6) and
copy associated names (2 columns to left) to a seperate
sheet.

I've had support on this code previously (thanks Dick)
but we seem to have run up against a brick wall on one
specific aspect.

The VBA code works............but only if the cells
contain the physical numeric or text. In reality, the
cell contains a formula that produces the numeric (1 or
2) or the text ("Ladies"). Doing a search where the cell
contains a formula does not find the numeric or text that
is displayed for all to see.

Is there a way to overcome this, dare I say,
deficiency ????

Thanks in anticipation