S
SS
Hi,
I was hoping to find a good way to do the following.
I have a table that consists of blocks of data 5 columns wide and a
variable number of rows for each block.
There are no spaces in between, just stacked data. The one
commonality in each block is column A values, such as the value
123456Lab. In this 123456Lab block, all rows will have column A value
of 123456Lab, for lets say 8 rows. This block could be located
anywhere vertically in the data table.
I need to search for the variable, in this case 123456Lab, and select
the entire range (this block is 8 rows by 5 columns).
The variable will be a listbox entry; so basicall a cell vaue entry.
Any ideas on the best way to find and select the above range?
That range will then be copy/pasted someplace else (I think I can do
that part).
Also, I will be going back and selecting that same row range later and
deleting the rows, so they are gone. If any ideas there as well?
Thanks Again!
Steve
I was hoping to find a good way to do the following.
I have a table that consists of blocks of data 5 columns wide and a
variable number of rows for each block.
There are no spaces in between, just stacked data. The one
commonality in each block is column A values, such as the value
123456Lab. In this 123456Lab block, all rows will have column A value
of 123456Lab, for lets say 8 rows. This block could be located
anywhere vertically in the data table.
I need to search for the variable, in this case 123456Lab, and select
the entire range (this block is 8 rows by 5 columns).
The variable will be a listbox entry; so basicall a cell vaue entry.
Any ideas on the best way to find and select the above range?
That range will then be copy/pasted someplace else (I think I can do
that part).
Also, I will be going back and selecting that same row range later and
deleting the rows, so they are gone. If any ideas there as well?
Thanks Again!
Steve