Auto fill sheet reference in hyperlink formula

[Giovannii]

Hello everyone.

I am trying to auto-fill the sheet references(indicated in red) in the following equations

<table border="0" cellpadding="0" cellspacing="0" width="540"><col style="width: 405pt;" width="540"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt; width: 405pt;" height="17" width="540">=HYPERLINK("#1068!A1", "2455-" & H1073)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">=HYPERLINK("#1068!A1", "2455-" & H1074)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">=HYPERLINK("#1068!A1", "2455-" & H1075)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">=HYPERLINK("#1068!A1", "2455-" & H1076)</td> </tr> </tbody></table>

It should read as follows:
<table border="0" cellpadding="0" cellspacing="0" width="540"><col style="width: 405pt;" width="540"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt; width: 405pt;" height="17" width="540">=HYPERLINK("#1068!A1", "2455-" & H1073)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">=HYPERLINK("#1069!A1", "2455-" & H1074)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">=HYPERLINK("#1070!A1", "2455-" & H1075)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">=HYPERLINK("#1071!A1", "2455-" & H1076)</td> </tr> </tbody></table>.

The red indicates sheets in a workbook. I need the hyperlink to read 2455-####, which is the latter part of the hyperlink formula.

I have tried the INDIRECT formula in combination with with this formula, but i did not have any luck. I do have another column that i can reference with the sheet numbers.

Any help would be GREATLY appreciated.

Thank you.

 

[shg]

Not sure what you're trying to do -- maybe this?

=HYPERLINK("#" & H1073 & "!A1", "2455-" & H1073)

 

[Giovannii]

Thank you so so so so much.

I have tried a variation of that, but my quotes were in the wrong place.

Thank you very very kindly.