Is there anyway I can have a hyperlink reference a cell which stays on the same sheet it's on?
So for example, if I have a hyperlink going to cell B28 in the sheet named 'August', I want to be able to copy that sheet and name it 'September'. However the link stays with the B28 cell in the...