ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Dependent Dropdown List - Not Easy! (https://www.excelbanter.com/excel-worksheet-functions/138963-dependent-dropdown-list-not-easy.html)

kditty02

Dependent Dropdown List - Not Easy!
 
I have already used the dropdown suggestion in contexis's website and it does
work. The question I have is in regards to the fact that I am looking to
convert my spreadsheet to HTML and no one can do it with OFFSET function
being in the Data Validation section. So, is there another way to achieve
this same result of a dependent dropdown list without using the OFFSET
function in Data Validation.. or does someone know of a spreadsheet to HTML
conversion tool that can use this function?

Said it wouldn't be easy! Thanks to all who can chime in!!!

Bob Phillips

Dependent Dropdown List - Not Easy!
 
I show an HTML version at http://www.xldynamic.com/source/xld.Dropdowns.html
that you can lift.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"kditty02" wrote in message
...
I have already used the dropdown suggestion in contexis's website and it
does
work. The question I have is in regards to the fact that I am looking to
convert my spreadsheet to HTML and no one can do it with OFFSET function
being in the Data Validation section. So, is there another way to
achieve
this same result of a dependent dropdown list without using the OFFSET
function in Data Validation.. or does someone know of a spreadsheet to
HTML
conversion tool that can use this function?

Said it wouldn't be easy! Thanks to all who can chime in!!!




kditty02

Dependent Dropdown List - Not Easy!
 
I just sent it to the people who do the conversion for me... Thank you for
the info!

Any other hints??


All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com