View Single Post
  #1   Report Post  
florin
 
Posts: n/a
Default copy a block of cells

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