|
Drop-down box
i have a drop down box and i find new things that i wish to add. but for
some reason i am unable to change the table and have it update on the excel spreadsheet the drop down is located. what can i do? |
Drop-down box
Peruse the Data Validation secions of Debra Dalgleish's Contextures website
and see if they help you identify your problem. http://www.contextures.com/xlDataVal01.html Also check the Dynamic Range section of that same site: http://www.contextures.com/xlNames01.html#Dynamic Does that help? *********** Regards, Ron XL2002, WinXP-Pro "sunderland27" wrote: i have a drop down box and i find new things that i wish to add. but for some reason i am unable to change the table and have it update on the excel spreadsheet the drop down is located. what can i do? |
Drop-down box
every time i do what is written, i lose my list. i am unable to use it as a
drop down box. it is missing. what am i doing wrong? "Ron Coderre" wrote: Peruse the Data Validation secions of Debra Dalgleish's Contextures website and see if they help you identify your problem. http://www.contextures.com/xlDataVal01.html Also check the Dynamic Range section of that same site: http://www.contextures.com/xlNames01.html#Dynamic Does that help? *********** Regards, Ron XL2002, WinXP-Pro "sunderland27" wrote: i have a drop down box and i find new things that i wish to add. but for some reason i am unable to change the table and have it update on the excel spreadsheet the drop down is located. what can i do? |
Drop-down box
what am i doing wrong?<<
Unless you post what you're actually doing, how can we know? Exaclty what Data Validation steps are you doing and what references are you using? *********** Regards, Ron XL2002, WinXP-Pro "sunderland27" wrote: every time i do what is written, i lose my list. i am unable to use it as a drop down box. it is missing. what am i doing wrong? "Ron Coderre" wrote: Peruse the Data Validation secions of Debra Dalgleish's Contextures website and see if they help you identify your problem. http://www.contextures.com/xlDataVal01.html Also check the Dynamic Range section of that same site: http://www.contextures.com/xlNames01.html#Dynamic Does that help? *********** Regards, Ron XL2002, WinXP-Pro "sunderland27" wrote: i have a drop down box and i find new things that i wish to add. but for some reason i am unable to change the table and have it update on the excel spreadsheet the drop down is located. what can i do? |
Drop-down box
i did what it said via this link
http://www.contextures.com/xlNames01.html#Dynamic "Ron Coderre" wrote: what am i doing wrong?<< Unless you post what you're actually doing, how can we know? Exaclty what Data Validation steps are you doing and what references are you using? *********** Regards, Ron XL2002, WinXP-Pro "sunderland27" wrote: every time i do what is written, i lose my list. i am unable to use it as a drop down box. it is missing. what am i doing wrong? "Ron Coderre" wrote: Peruse the Data Validation secions of Debra Dalgleish's Contextures website and see if they help you identify your problem. http://www.contextures.com/xlDataVal01.html Also check the Dynamic Range section of that same site: http://www.contextures.com/xlNames01.html#Dynamic Does that help? *********** Regards, Ron XL2002, WinXP-Pro "sunderland27" wrote: i have a drop down box and i find new things that i wish to add. but for some reason i am unable to change the table and have it update on the excel spreadsheet the drop down is located. what can i do? |
Drop-down box
Ok...now we know exactly how the esteemed Ms. Dalgleish did it...but still
have no specifics on your attempts. What sheet name contains your list? What cells in that sheet contain the list? Is your Data Validation cell on another sheet? What EXACT steps are you employing to create the Data Validation? (include: your inputs to the parameters) Did any of your approaches ever work? *********** Regards, Ron XL2002, WinXP-Pro "sunderland27" wrote: i did what it said via this link http://www.contextures.com/xlNames01.html#Dynamic "Ron Coderre" wrote: what am i doing wrong?<< Unless you post what you're actually doing, how can we know? Exaclty what Data Validation steps are you doing and what references are you using? *********** Regards, Ron XL2002, WinXP-Pro "sunderland27" wrote: every time i do what is written, i lose my list. i am unable to use it as a drop down box. it is missing. what am i doing wrong? "Ron Coderre" wrote: Peruse the Data Validation secions of Debra Dalgleish's Contextures website and see if they help you identify your problem. http://www.contextures.com/xlDataVal01.html Also check the Dynamic Range section of that same site: http://www.contextures.com/xlNames01.html#Dynamic Does that help? *********** Regards, Ron XL2002, WinXP-Pro "sunderland27" wrote: i have a drop down box and i find new things that i wish to add. but for some reason i am unable to change the table and have it update on the excel spreadsheet the drop down is located. what can i do? |
| All times are GMT +1. The time now is 06:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com