The below post would help.

http://contextures.com/xlNames01.html#Dynamic
--
If this post helps click Yes
---------------
Jacob Skaria


"GooseMA" wrote:

Hi, I modified the data that appears in a drop down menu but it won't
recognize the new data. Any ideas ?

The drop down menu & the data for the drop down menu are located in the same
workbook, separate worksheets.

thx!