I am having trouble when hyperlinking to pg two, on pg 2 would like to keep the hyperlink to stay on it and not return to pg 1.
Cell A1 = 5
Cell A2 = 10
Cell A3 =A1 or 5 and hyperlink back to Cell A1
Cell A4 =A2 or 10 and hyperlink back to Cell $A$2
On Sheet 2 is a duplicate of sheet 1--when hyperlink goes to page two and you hit A1--it returns to sheet 1 instead of staying on sheet 2. I will have 12 sheets for 12 months with same infor and want hyperlinks to stay on sheet I am working on.
I use Absolute and Relative to accomplish this but it still hyperlinks back to sheet 1 instead of staying on sheet 2????
Now the clincher--how do I copy Sheet 1 to Sheet 2 and on Sheet 2 have the hyperlinks stay on sheet 2 and not jump back to sheet 1 .
Please give detail steps how to do this as I have tried numerous times to accomplish sheet 2 hyperlinks staying in sheet 2 when you copy and paste them instead of changing them manually??????
Thanks for any help.
Cell A1 = 5
Cell A2 = 10
Cell A3 =A1 or 5 and hyperlink back to Cell A1
Cell A4 =A2 or 10 and hyperlink back to Cell $A$2
On Sheet 2 is a duplicate of sheet 1--when hyperlink goes to page two and you hit A1--it returns to sheet 1 instead of staying on sheet 2. I will have 12 sheets for 12 months with same infor and want hyperlinks to stay on sheet I am working on.
I use Absolute and Relative to accomplish this but it still hyperlinks back to sheet 1 instead of staying on sheet 2????
Now the clincher--how do I copy Sheet 1 to Sheet 2 and on Sheet 2 have the hyperlinks stay on sheet 2 and not jump back to sheet 1 .
Please give detail steps how to do this as I have tried numerous times to accomplish sheet 2 hyperlinks staying in sheet 2 when you copy and paste them instead of changing them manually??????
Thanks for any help.