Hyper link reference to sheet number

**faisal.ta** · 12-01-2013, 02:40 PM

Hi
I have created 10 Hyperlinks in sheet 1. And all these links in the same sheet.
When i copy the same sheet to sheet 2, the sheet 2 hyperlink is related or is reffered to sheet.
Is it possible that when we copy teh sheet to next sheet, the hyperlink also gets copied with the sheet number

Faisal

**FDibbins** · 12-01-2013, 05:13 PM

You can probably use INDIRECT() for this, what does for formula look like - perhaps share a sample workbook to play with?

**faisal.ta** · 12-01-2013, 05:28 PM

Hi
Please check the attached sheet.
In sheet 1 is my master sheet which i need to copy 30 times for monthly entry. But when i copy to teh next sheet the hyperlink in 2nd sheet refers to the link cells in sheet 1.
The hyperlinks are given in the buttons in the top left corner.

Regards