I have created a database that has 2000+ entries that are reviewed weekly. The items are maintained on a sheet called import. On a sheet titled calculations, I have created a drop down list of all of the entries in cell G2. Once the item is selected in G2 a number of calculations are completed and an analysis is done very quickly. I then have to select G2, press arrow down and enter for the next item on the list to be evaluated. I am looking to create a macro to assign to a button that will automate that process of selecting the next item In the drop down list. Tired of pressing keys 6000 times to look at 200 items.
any help would be appreciated!
any help would be appreciated!