Been trying to make a fairly large report more user friendly so I had the bright idea of adding in a drop down box that would let you jump to the section on the page you want.
Set up the list, named the relevant cells and found the IF statement that would link everything in the help files so I've changed the example names to the right ones.
Does it work?
Does it bugger!!! Excel doesnt like the formula I got from its own bleedin' help files