Florin, how about setting the table to auto filter and then filtering the
data in the first column to get the required set of data (that u rferred as
same text)
That way you will see all these spread out records consecutively.
Because they now appear as a block, it wont be difficult to selet them
manually.
Hope this helps


"florin" wrote:

hello everyone,

i do have to copy a block of data from its location to somewhere else into
the same worksheet. the problem is that the block of cells is not fixed, so i
need some sort of function to look up for it. the block of cells that i need
to copy have the following characteristics:
-the cells are always found on the same columns, although they could be
found anywhere along these columns (not on specific rows)
-the data from the first column always contains the same text while the data
on the next columns is always numbers
-all raws under this block are empty

I appreciate any suggestions you may have.

Florin