| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlink
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hyperlink
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 wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hyperlink
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" wrote: 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 wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hyperlink
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 wrote: 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" wrote: 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 wrote: 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 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hyperlink
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" wrote: 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 wrote: 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" wrote: 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 wrote: 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 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hyperlink
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. stew wrote: 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" wrote: 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 wrote: 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" wrote: 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 wrote: 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 -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hyperlink
thanks dave, worked a treat
Best Stew "Dave Peterson" wrote: 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. stew wrote: 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" wrote: 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 wrote: 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" wrote: 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 wrote: 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 -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert hyperlink function into hyperlink | Excel Worksheet Functions | |||
| Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
| How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
| Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Linear Mode
