Drop Down List in Excel 2007
 

I would like to choose a name that I have created from a Drop Down List and
then be redirected to the corresponding cell in the spreadsheet.

Drop Down List in Excel 2007
 

The name is a defined rangename you created in InsertNameDefine?

And this name refers to a particular cell?

Would be easier to click on the NameBox and select the name from there.

Or F5 and pick the name from there and OK


Gord Dibben MS Excel MVP

On Wed, 2 Sep 2009 07:00:05 -0700, Dan
wrote:

I would like to choose a name that I have created from a Drop Down List and
then be redirected to the corresponding cell in the spreadsheet.