Automating a list to select the next item

Jnolette

New Member
Joined
Jan 25, 2021
Messages
1
Office Version
  1. 365
Platform
  1. MacOS
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!
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

aRandomHelper

Board Regular
Joined
Jan 14, 2021
Messages
241
Office Version
  1. 2016
Platform
  1. Windows
I have created a drop down list of all of the entries in cell G2
Maybe you have to provide more info on this. How are the entries determined? every single row from import? or unique values of a certain column? or? How are you setting up the drop down list? data validation on a single excel's range column? named range? or?
 

Watch MrExcel Video

Forum statistics

Threads
1,128,129
Messages
5,628,865
Members
416,347
Latest member
AT2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top