Previous Topic Next Topic

How to manage drop list

Closed
a_elgazar Posts 5 Registration date Thursday October 27, 2016 Status Member Last seen November 5, 2016 - Oct 30, 2016 at 07:26 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Nov 1, 2016 at 11:51 AM
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

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 545
Nov 1, 2016 at 11:51 AM
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
0