Drop Down Lists

[Cmennis]

Hi again,

I know this is basic excel 101 but for the life of me I cannot remember and
can't get the "Help" file to give me an answer.

I have a workbook with 5 worksheets in it. One of the sheets has drop down
lists that are supposed to be updated from another of the worksheets.

Ain't happenin.

Any suggestions or just a straight up solution would be very much
appreciated.

I would love to have this problem corrected before my boss comes to ask why
I'm not done all of my entries - about 1-2 hours from now.

Thank you all in advance.

Cmennis

 

[Don Guillett]

http://www.contextures.com/tiptech.html

 

[Debra Dalgleish]

If these are data validation lists, perhaps new items were added to the
end of the master list, and those new rows aren't included in the range
used for the data validation list.

If that's the problem, change the range definition (Insert>Name>Define)
or create a dynamic range, as described here:

http://www.contextures.com/xlNames01.html#Dynamic

 

[Don Guillett]

Speak of the devil and she shows up in the flesh. <G>

 

[Debra Dalgleish]

So be careful what you say! I have eyes in the back of my head too.