Put a dropdown list that allows me to quickly go to another existing worksheet (and will autopopulate with new worksheets)
Posted on 2015-01-30
wondering how to do this...and wondering if it's possible to do with formulas rather than code. I've attached a file with 3 worksheets - Larry, Curley and Mo. How can I set up a dropdown list on each sheet e.g. on Larry - that will show me Curley and Mo and that will bring me to that sheet if I click on it. And if I decided to add to my motley crew e.g. Laurel, Hardy etc it will automatically update.
Thanks as always :-)