Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down Lists
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down Lists
http://www.contextures.com/tiptech.html
-- Don Guillett Microsoft MVP Excel SalesAid Software "Cmennis" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down Lists
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 (InsertNameDefine) or create a dynamic range, as described he http://www.contextures.com/xlNames01.html#Dynamic Cmennis wrote: 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 -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down Lists
So be careful what you say! I have eyes in the back of my head too.
Don Guillett wrote: Speak of the devil and she shows up in the flesh. <G -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists | Excel Discussion (Misc queries) | |||
Drop down lists? | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions |