conditional statement to find more than one value ??
I'm trying to find a value in a row based on the cell color
If colorIndex = 8 Then 'row loop
check the row and find the first cell with colorIndex = 8
If color = 8 is find then 'column loop
'copy cell value destination new cell
Keep going thru the row and find all cell with that color and copy
values
End if 'column loop
Else 'row loop
go to next row
End if 'row loop
The objective is to go through Column A and find the colored cells. Then
find on that cell row checking by columns if there are one or more colored
cells and copy the values to a new list.
Will a loop inside a loop do it?
As usual, any help will be appreciated. Specially today, I seem to be having
a brainless day...
--
gaba :)
|