I am working in a gigantic spreadsheet in which some cells I use very frequently. Usually I get to this filters through filtering. This is frustrating since I need to clear my current selection, apply two filters, find and update the cell and then restore my other filters. I am currently writing down what I need to update and then just do it all in one go, but its slightly more mistake-prone.
Is there a way to directly link to a favorite cell, for example by creating something of a live link in which I can update either side of the linked cells and the result will show in the other as well? Is there a way to jump to a pre-defined entry number?
Help would be greatly appreciated.
Bookmarks