Cycling through precedents

QuoUsqueTandem

New Member
Joined
Nov 9, 2017
Messages
4
Hi all,

At my previous employer we had a tool/shortcut that allowed us to click on a cell containing a formula and then cycle through its precedents using shortcuts. The cycle was started off with CTRL+G (repurposed from Microsoft's default use) and then you could move to each precedent of the original formula in turn with repeated presses of CTRL+N. With each press of the 'next' shortcut, the next precedent in the cycle would be selected and the screen would navigate to it. Pressing CTRL+G while one of the precedents was selected would end the cycle and start a new one, taking the user to the first precedent of that cell.

The tool worked even where certain of the precedents were on a different worksheet within the same workbook (reading through the previous posts regarding precedents, that seems to be a pertinent point), although it did not unhide/expand hidden or grouped rows. To get back to the original cell of the current cycle (i.e. the one containing the formula you were interrogating) you'd just press CTRL+N until all of the precedents had been visited and the next press of the shortcut took you back to it.

The tool saved so much time that the built-in precedent tool barely got used. I'm really missing it in my new role and wonder if anyone knows of a tool or has some code that does what I've described. If not, I'd like to cobble together an imitation so any help or advice would be really appreciated.

Cheers,
QUT
 

QuoUsqueTandem

New Member
Joined
Nov 9, 2017
Messages
4
Thanks for getting back to me - I had found that product but its tracing isn’t suitable for our purposes. We use the tracing tool to interrogate models that have been produced by other people for legal cases so they’re frequently messy or poorly built. The precedents tend to be scattered all over the place in illogical places so we really need to be taken to them by the tool, rather than just having a preview of their location.
 

QuoUsqueTandem

New Member
Joined
Nov 9, 2017
Messages
4
Thanks - that looks like the closest to what I wanted to reproduce. A bit too much interface but the functionality seems to be what I'm looking for.
 

Forum statistics

Threads
1,082,126
Messages
5,363,315
Members
400,725
Latest member
excelingtolearn

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top