A way to directly access favorite cells

**Hanny304** · 05-28-2012, 04:58 AM

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.

**Russell Dawson** · 05-28-2012, 05:07 AM

In a convenient blank cell - Insert< Hyperlink< In this document< input cell ref< select sheet<name as appropriate < OK

**benishiryo** · 05-28-2012, 05:12 AM

hi Hanny304, welcome to the forum~ i think it'll be good if u can upload a sample? i dont know if a simple hyperlink can help u. since u mentioned applying 2 filters, i suppose it's not that direct. try show use what u need to achieve in the file

**Pepe Le Mokko** · 05-28-2012, 05:31 AM

Benishiryo are you using SMS writing or is my English outdated ?

**benishiryo** · 05-28-2012, 05:44 AM

Benishiryo are you using SMS writing or is my English outdated ?

do i need to go through all of your posts & find spelling/grammer errors? try doin somethin useful instead by helping them solve Excel problems. u can PM me for any other non-Excel problems u need to clear with me

**Pepe Le Mokko** · 05-28-2012, 11:12 AM

Temper, temper my friend. We are all civilized people here. And I don't think using "u" instead of " you" is an error.

**Hanny304** · 05-28-2012, 12:27 PM

Thanks a bunch Russel, that really helps!

If there would be a way to also hotkey a preset filter I would be done with this. Is this possible in excel?

As far as the sample goes, its more or less sensitive data. If it would be required I could create a dummy version of course, but now that I have something of a link, I only need to be able to quickly get back to my original filter settings. Unless there is a way I can access the hyperlinked cell while keeping the filter (which excludes this cell)

**Russell Dawson** · 05-28-2012, 02:49 PM

You could create a macro via a button on the s/s but if you want it to run via a double click in a cell then I think you need VBA code to do this and it's out of my league I'm sad to say. I'm learning, but slowly.

If you want help re the button I can certainly help (see attachment as example) but if you prefer to go down the VBA route I'd suggest starting another thread entitled "VBA needed to run Macro by clicking cell". It's really a different question to the original. There is some stuff already out there so you may want to have a look first. It depends upon how comfortable you are.

Cheers

Russell