S
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
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