I have hyperlinks that I need to autofill down one column (900 rows). The
end of the link has the cell number of the other worksheet and I need this
cell number to change every 6 rows to the next number in a sequence of 3.
Keep in mind I am VBA deficient. Thanks.
Example.
Col A
Rw 1 C:...C7
Rw 2 C:...C7
Rw 3 C:...C7
Rw 4 C:...C7
Rw 5 C:...C7
Rw 6 C:...C7
Rw 7 C:...C10
Rw 8 C:...C10
Rw 9 C:...C10
Rw 10 C:...C10
Rw 11 C:...C10
Rw 12 C:...C10
Rw 13 C:...C13
Rw 14 C:...C13
Rw 15 C:...C13
Rw 16 C:...C13
Rw 17 C:...C13
Rw 18 C:...C13

This formula will create the pattern you're looking for:

=INT((ROW()/6)-0.1)*3+7

HTH,
Elkar


"Gayla" wrote:

I have hyperlinks that I need to autofill down one column (900 rows). The
end of the link has the cell number of the other worksheet and I need this
cell number to change every 6 rows to the next number in a sequence of 3.
Keep in mind I am VBA deficient. Thanks.
Example.
Col A
Rw 1 C:...C7
Rw 2 C:...C7
Rw 3 C:...C7
Rw 4 C:...C7
Rw 5 C:...C7
Rw 6 C:...C7
Rw 7 C:...C10
Rw 8 C:...C10
Rw 9 C:...C10
Rw 10 C:...C10
Rw 11 C:...C10
Rw 12 C:...C10
Rw 13 C:...C13
Rw 14 C:...C13
Rw 15 C:...C13
Rw 16 C:...C13
Rw 17 C:...C13
Rw 18 C:...C13