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: 874
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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, 5 views)
Reply With Quote