HYPERLINK formula help

[welshman010]

Hi

I have created a table and one of the columns displays the table row number. I have created sheets numbered 1-300. I been trying to use the hyperlink formula referencing the row number as the the worksheet number to link to.

I was hoping as the table expanded and row numbers increased the formula would copy down linking to corresponding worksheets.

Is this possible?

Any tips be great.

Thanks

[Pete_UK]

Yes, it is possible, but I'm not sure from your description where your data is located nor where on the destination sheet you want to jump to (cell A1 ?). Please attach a sample workbook (it doesn't need all 300 sheets) so it might become a bit clearer what you want to do.

Pete

[aavins73]

Pls. take a look at this..

Please Login or Register  to view this content.

Change the A1 cell reference to cell where you have numbers and drag it down till 300

[welshman010]

Thanks for replies. I just solved it, using this formula

Please Login or Register  to view this content.