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

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

thank you for the hint! i'll try that!

"Oblik" wrote:

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