I have a simple model/table that I'm constantly adding new rows that are range defined. In my attached file, I have three separate sections that are identified and expanded by an Outline format using a macro that selects/provides details.
What I need is a Macro that also allows me to quickly get to and isolate a single FA (range). I would see it as a form, that includes a drop down box that is linked to a "table" on another WS; where I can add a section name (that will be related to a new FA range name).
The result is that I should be able to either/both "Select Detail" (already works) and "Select FA" (what the new macro will do) and as I add more and more rows, I can quickly get to the correct FA and the detail, without simply selecting the detail and having to scroll down a huge set of rows.....
I have attached a file for your review. The Select FA is the button that has no macro yet.