hyperlink

[stew]

Dear All

Trouble with the Following
=HYPERLINK("#'tour manager euro sheet'!a"&INT(((ROW()-5)/2)*43)+1,"VIEW")

This Formula is repeated In a Column on a seperate worksheet. The Intention
Being that every second Row in the column the Hyperlink should take me 44
Rows on in 'tour manager euro sheet' on column a

Can anybody help the hapless soul

Best

Stew

 

[Dave Peterson]

The formula provided a hyperlink that worked fine for me--if I put it in a cell
in row 5 or more. (Before row 5 and it would evaluate to a negative row.)

Since the hyperlink depends on the cell containing the formula, I'm not sure
what your first formula should be.

Can you share the first few cells that get the formula--and the corresponding
address that you want to hyperlink to?

 

[stew]

Hi Dave
Formula starts in B7 which should take me to 'tour manager euro sheet' a44,
which it does but when it is repeated all the way down when i get to b12 it
should take me to a148 but it takes me to a151

Hope this helps

Stew

 

[Dave Peterson]

I still don't get the pattern:

Please be explicit.

B7 --> A44
B8 -->
B9 -->
B10 -->
B11 -->
B12 -->

If each was incremented by 21, I'd end up with A149.

44
65
86
107
128
149

 

[stew]

Hi Pete

Here we Go

B7 --> A44
B8 --> A65
B9 --> A86
B10 -->A107
B11 -->A128
B12 -->A149

Now i see it like this I think my Increments are Wrong

Best

Stewart

 

[Dave Peterson]

This is the part of the formula that I wanted to experiment with:
INT(((ROW()-5)/2)*43)+1

So I used a test worksheet and put this in row 7:
=(21*(ROW()-7+1))+23
and dragged down and it seemed to work ok.

So...

=HYPERLINK("#'tour manager euro sheet'!a"&(21*(ROW()-7+1))+23,"VIEW")

Seemed to work ok.

Hi Pete

Here we Go

B7 --> A44
B8 --> A65
B9 --> A86
B10 -->A107
B11 -->A128
B12 -->A149

Now i see it like this I think my Increments are Wrong

Best

Stewart

 

[stew]

thanks dave, worked a treat

Best

Stew

This is the part of the formula that I wanted to experiment with:
INT(((ROW()-5)/2)*43)+1

So I used a test worksheet and put this in row 7:
=(21*(ROW()-7+1))+23
and dragged down and it seemed to work ok.

So...

=HYPERLINK("#'tour manager euro sheet'!a"&(21*(ROW()-7+1))+23,"VIEW")

Seemed to work ok.