dependent

Surely someone has made dependent List Box (Form Controls) before? How is this done since you cannot use INDIRECT()? I've tried searching, but everyone references the Data Validation / Indirect method? I'm looking for something that would use the List Box Form Control. Thanks!

I am trying to have cell values of 1-1, 1-2, 1-3, 1-.... My guess is this would be most easily achieved through editing the format. I would like it so when I drag the cell containing 1-1 the next cell will have the value 1-2, and the following 1-3 and so on. Secondly, I would like a cell to be...

I am trying to put in a collapsible panel into a form similar to that found half way down the page at: https://register.cc-hubwoo.com/CompanyInformation.aspx? its the panel below "Select the Products & Services your company provides based on:" and for UNSPSC. these are united nations codes used...

I have the "Learn Excel 97 through Excel 2007 from MrExcel" book.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I was successfully following the “Use Validation to Create Dependent Lists” on Page 900.<o:p></o:p> Everything was working great.<o:p></o:p> I...

Hi everyone. I need some help with my spreadsheet, maybe someone can figure it out. Basically i need excel to insert a block of cells from another sheet (including the dropdown menus and formulas in the blocks.) Ill try and draw what i mean: This would be what you see whe you begin...

I started with this http://www.contextures.com/xlDataVal13.html which told me how to do dependent validation lists. It works well, however I need to force blanks or clear out the Customer. My question is this and I'll use the page above as a reference: If I clear out a Region, the Customer is...

Hi there. First post for me. My problem is pretty simple (I think) but I am still having some trouble. If you look at the table below. This spreadsheet tracks the number of pieces of fruit sold. I enter the fruit name and quantity. Below I would like it to automatically keep track of the total...