Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find and IF statement | New Users to Excel | |||
comlex Find statement | Excel Discussion (Misc queries) | |||
If statement to find NA() | Excel Worksheet Functions | |||
If statement to find NA() | Excel Worksheet Functions | |||
when a Find statement is successful | Excel Programming |