Stephan
Member
Data Validation combo box approaches for XL Dashboards?
My new project ex0 ZIP file 1.4MB, 1st tab Dashboard DV boxes Cells S2 & S5 either use manual DV or Defined Name sort approach (see tab CITIES), 2nd tab raw data 8000 rows & 50 Columns. DV alternative may speed up data processing, unless just my laptop! Advise if file doesn't bring your LAPTOP to standstill on selection of Combo Boxes!
Defined Name sort > hugh projects significantly slow CPU & increase file size. ex0
Index Match Countif > hugh projects significantly slow CPU & increase file size. ex1 DV attached 4Col R100 AZ SEC.xls my own developed version of dynamic data validation
Indirect Substitute > time consuming to create for each category & sub category. ex2 attached DVIndSubOffV.xls
Offset Match Countif > hugh projects significantly slow CPU & increase file size. ex3
Many Dashboards, few use automation, just manually enter or Defined Name Range, but for large projects these just aren't viable, advisory comments or example files would be useful!
My new project ex0 ZIP file 1.4MB, 1st tab Dashboard DV boxes Cells S2 & S5 either use manual DV or Defined Name sort approach (see tab CITIES), 2nd tab raw data 8000 rows & 50 Columns. DV alternative may speed up data processing, unless just my laptop! Advise if file doesn't bring your LAPTOP to standstill on selection of Combo Boxes!
Defined Name sort > hugh projects significantly slow CPU & increase file size. ex0
Index Match Countif > hugh projects significantly slow CPU & increase file size. ex1 DV attached 4Col R100 AZ SEC.xls my own developed version of dynamic data validation
Indirect Substitute > time consuming to create for each category & sub category. ex2 attached DVIndSubOffV.xls
Offset Match Countif > hugh projects significantly slow CPU & increase file size. ex3
Many Dashboards, few use automation, just manually enter or Defined Name Range, but for large projects these just aren't viable, advisory comments or example files would be useful!