I have a spreadsheet that I download from a database that has thousands of combinations. I know that on a small scale I could create named ranges and create a conditional autofilter, but that will not work in this case because there are so many combinations and the spreadsheet updates all the time.
Excel does a great job of what I am trying to do...however, I want it to be more customized into my format. Lets say you have a table that has many rows that share specific values. When you autofilter the entire table, as you select from each column's dropdown list, the number of line items gets smaller and smaller (eg. filter by column A, then filter by column B, etc.). After you have filtered column A, when you select the dropdown from column B, the list of options in column B updates automatically to only the options available. Then you can choose column C, and so on and so on. This is perfect. However, I do not want my customers seeing the entire table as they are filtering. I want them to choose column A, then column B, then column C and then get a desired cell value from the final line item.
Can anyone tell me how to do this where I can set this up on Sheet 1 as my inputs, where it is pulling the data from the table in Sheet 2? Basically, I want sheet 1 to be a selection form and sheet two to contain the data tables.
Any help would be appreciated.
Tim
Excel does a great job of what I am trying to do...however, I want it to be more customized into my format. Lets say you have a table that has many rows that share specific values. When you autofilter the entire table, as you select from each column's dropdown list, the number of line items gets smaller and smaller (eg. filter by column A, then filter by column B, etc.). After you have filtered column A, when you select the dropdown from column B, the list of options in column B updates automatically to only the options available. Then you can choose column C, and so on and so on. This is perfect. However, I do not want my customers seeing the entire table as they are filtering. I want them to choose column A, then column B, then column C and then get a desired cell value from the final line item.
Can anyone tell me how to do this where I can set this up on Sheet 1 as my inputs, where it is pulling the data from the table in Sheet 2? Basically, I want sheet 1 to be a selection form and sheet two to contain the data tables.
Any help would be appreciated.
Tim
