ExcelBanter - How do I link info from a key sheet to drop down lists in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I link info from a key sheet to drop down lists in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/255268-how-do-i-link-info-key-sheet-drop-down-lists-excel.html)

janiece

How do I link info from a key sheet to drop down lists in Excel?

Gord Dibben

How do I link info from a key sheet to drop down lists in Excel?

Use this large white space to provide some details, please.

To use another sheet as a source for your DV dropdown lists you must name
the source range............I will use the defined name MyList

Then in DV list source you enter =MyList

Gord Dibben MS Excel MVP

On Wed, 3 Feb 2010 14:08:01 -0800, janiece
wrote:

All times are GMT +1. The time now is 07:11 AM.