how to manage drop listClosed

Question

Hello, 

if  i have  two dependent  drop list   one  in E15  include  3  item  ( only fresh ; only exhaust and both ) other  in  f 15 

when select  "only  fresh " related  data appear   on it  

i need  to  modify  this  drop list  if i  choose  from  the first  " only exhaust "  to  be  empty ( cleared ) 

thanks 

Configuration: Windows 7 / Chrome 54.0.2840.71

TrowaD · Answer

Hi a_elgazar,

So you created a named range called "only fresh" with data that will appear when "only fresh" is selected in the first drop down list, right?

Then create another named range for "only exhaust", which is empty.

Will that work or did I misinterpreted your question?

Best regards,
Trowa

How to manage drop list

1 response

Similar discussions

Subscribe To Our Newsletter!