How to manage drop list [Closed]

Report
Posts
5
Registration date
Thursday October 27, 2016
Status
Member
Last seen
November 5, 2016
-
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
-
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

1 reply

Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!