Thread: First of all check to cells and after drop down list
View Single Post
 
Old 11-27-2019, 12:15 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Added is a solution without any code. (All columns/sheets with 'Hidden' in name may be hidden).


The same can be done without defining Tables - using dynamic Named Ranges instead. But formulas will be more cumbersome.
Attached Files
File Type: xlsx DynamicListEexample.xlsx (17.9 KB, 7 views)
Reply With Quote