Next z loop

[PDBartlett]

Hello

I can't quite figure out how to get the line in blue to do the same as the 15 lines below it. For every 5 x's, the range cell needs to add 5 (D2, D7, D12 etc)

Please Login or Register  to view this content.

Thanks

[:) Sixthsense :)]

Replace this...

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

[PDBartlett]

Thank you, but it doesn't quite work!

Everything is equalling D2:D6

[:) Sixthsense :)]

Everything is equalling D2:D6

I don't think so...

[PDBartlett]

Ok so for each z there are 5 x's.

X (1) = D2 to X (5) = D6

With your code, within every z, all x's equal as above

Hmmm

[:) Sixthsense :)]

May be this?

Please Login or Register  to view this content.

[romperstomper]

Perhaps:

Please Login or Register  to view this content.

[PDBartlett]

Nailed it Rory!

It was a tricky one!