Solved Excel hyperlink to other sheet

December 4, 2015 at 15:56:36
Specs: Windows 64
I have created buttons with hyperlinks to other excel sheets in the same workbook, but I would like the sheets to appear with the selected cell being the last one which was edited/saved on that sheet.

I can only find how to either go to a specific cell or, by omitting the "cell reference", cell A1.

Any solution please?

See More: Excel hyperlink to other sheet

Report •

December 4, 2015 at 17:08:40
✔ Best Answer
I'm not sure Excel keeps track of the Last Cell Saved.
and I know of know way to keep track of such information,
especially if your talking multiple sheets.

If the data is always entered as the last cell in a Row or Column,
then there may be a solution.

It _may_ also be possible with a MACRO, but I do not have the skill
or knowledge to answer to that type of solution.


Report •

December 6, 2015 at 17:35:43
Thanks - I'm fairly certain that you are correct - Excel has no record of the last cell accessed in each sheet.

Report •
Related Solutions

Ask Question