Create drop list jump to reference cell

Hi all,

I'm trying to create a drop list in excel that will jump to a reference cell when selected.

For example, the list will list 12 months (Jan, Feb, March, Apr, May... to Dec). How do I go about doing it such that when I select Jan, Feb, Mar etc, it'll jump to the respective cell (example, cell A10 is Jan, A20 is Feb etc) and so on..?

Thanks.

Hi,
Name you cells then you can use the name drop down to select the range you want
If you are unfamiliar with naming ranges check this out
http://www.contextures.com/xlNames01.html

Maybe this event macro.

Right click the sheet name > select view code and paste in the below.

Change $A$1 to your dropdown cell and add the other months and ranges

Please Login or Register  to view this content.

VBA Noob

Your welcome

VBA Noob