I have a range of cells (D3:AJ19) that I would like to populate with
text value. It must qualify in three places.

Range AK3:AP3 must be "X"

Range (E34:J34) (E25:J25)

Range B3:B19 D1:AJ1

I don't know how to run all three loops at once. I want to evaluate al
three criteria before the value is placed in the original range. If i
suceeds got to the nect cell, if it fails go down to the next row.

Is this really that difficult?

Thank

--
Message posted from http://www.ExcelForum.com

i don't get it? what do you mean.. " Range (E34:J34) (E25:J25)" and "Range B3:B19 D1:AJ1
Do you mean the sum of the values in one range is the sum of the other, and if so don't you only have to test that once since it won't change. Please clarify what it is your testing for

----- hotherps wrote: ----

I have a range of cells (D3:AJ19) that I would like to populate with
text value. It must qualify in three places.

Range AK3:AP3 must be "X

Range (E34:J34) (E25:J25

Range B3:B19 D1:AJ

I don't know how to run all three loops at once. I want to evaluate al
three criteria before the value is placed in the original range. If i
suceeds got to the nect cell, if it fails go down to the next row

Is this really that difficult

Thank


--
Message posted from http://www.ExcelForum.com

No, not the sum I was just illustrating the ranges.

If E34 E25 then go to the next cell F34 F25 etc. until Column J

same idea for the other range.

What I'm saying is that all three of the following would have to be
true:

AK3 = "x"
E34 E25
B3 D1

and then the text value would appear. The part I'm having a problem
explaining is that some ranges are horizontal and some are vertical. It
should onnly test the cyle once and then loop to the next cell in the
range of D3 AJ19. I don't know how to phrase all 3 loops at once.

Thanks


---
Message posted from http://www.ExcelForum.com/