Intersect?

[gaba]

Hi everybody,
I have this project and I don't have a clue how to tackle it

The data I need to work with looks like this:

A B C D E
F
-65 0.004 = DL # 1 0.0049 123% 79
-66 # 2
-66 0.004 = DL # 1 0.0041 101% 80
-67 # 2
-67 0.080 = QC STD 2 # 1 0.0868 108% 81
-68 # 2
-68 REAGENT BLANK # 1 < 0.3125 82
-69 # 2
-69 4043-1 # 1 < 0.8602 NA 83
-70 # 2 < 0.8602
-70 782750 # 1 < 0.5674 NA 84
-71 # 2 < 0.5674
-71 4043-2/3-DUP # 1 < 0.6015 NA 85
-72 # 2 < 0.6015
-72 4043-4 # 1 < 0.5634 NA 86
-73 # 2 < 0.5634
-73 4043-5-SPK # 1 8.4457 150% 87
-74 # 2 8.5544 152%
-74 0.004 = DL # 1 0.0053 133% 88
-75 # 2
-75 0.004 = DL # 1 0.0041 103% 89
-76 # 2
-76 0.080 = QC STD 3 # 1 0.0855 107% 90

If (Column B) 0.004 = DL and 0.080 = QC (I need to compare only this part)
color index in column E is blue (#8) it means they are good values. Once I
find a "set of good values" I need to find the next set (the next two good
0.004 and 0.080) and select the data (Range(A?,F?) in between them. Cut and
paste the selection to Cell G14 (if is not empy, else find the next empy Row
in G)

If the next set (0.004 and 0.080) is not good (color index in E = 44) then
select the cells in between and set colorIndex = 40.

I don't know how to approach this one. How can I keep record of the first
set, find the next set and do something with the cells in between? Can I use
Intersect? I don't know which ranges are going to be good.

Any ideas would be greatly appreciated