Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers pop up manu

how create dynamic pop up menu

first menu is manufacture ( Kobelco, Komutsu, JCB, Caterpillar , ect)

when i select manufacture (Caterpillar) then second menu show only their product (D4k, D7, 312D)

MacBook Air (2020 or later)

Posted on Jul 8, 2021 10:49 AM

Reply
Question marked as Top-ranking reply

Posted on Jul 10, 2021 6:41 AM

Hi warunasanjeewa,


Start with this table


Select one column at a time and Format Panel > Data Format > Pop-Up Menu.

Do not select blank cells, or you will get blank entries in your Pop-Ups.


Copy A1 and paste into A1 of another table (I named it Cascading Pop-Ups)


Copy B1 of Machines and paste into Cascading Pop-Ups A2

Copy C1 of Machines and paste into Cascading Pop-Ups A3

And so on.


In B1 of Cascading Pop-Ups, type Show.

Formula in B2 of Cascading Pop-Ups: IF(A$1="Kobelco","Show","")

Formula in B3 of Cascading Pop-Ups: IF(A$1="Komutsu","Show","")

Formula in B4 of Cascading Pop-Ups: IF(A$1="JCB","Show","")

Formula in B5 of Cascading Pop-Ups: IF(A$1="Caterpillar","Show","")


Apply a filter to the Cascading Pop-Ups table:


To see this:



Now choose a manufacturer



Choose a Caterpillar product




You can hide Column B.


Regards,

Ian.

4 replies
Question marked as Top-ranking reply

Jul 10, 2021 6:41 AM in response to warunasanjeewa

Hi warunasanjeewa,


Start with this table


Select one column at a time and Format Panel > Data Format > Pop-Up Menu.

Do not select blank cells, or you will get blank entries in your Pop-Ups.


Copy A1 and paste into A1 of another table (I named it Cascading Pop-Ups)


Copy B1 of Machines and paste into Cascading Pop-Ups A2

Copy C1 of Machines and paste into Cascading Pop-Ups A3

And so on.


In B1 of Cascading Pop-Ups, type Show.

Formula in B2 of Cascading Pop-Ups: IF(A$1="Kobelco","Show","")

Formula in B3 of Cascading Pop-Ups: IF(A$1="Komutsu","Show","")

Formula in B4 of Cascading Pop-Ups: IF(A$1="JCB","Show","")

Formula in B5 of Cascading Pop-Ups: IF(A$1="Caterpillar","Show","")


Apply a filter to the Cascading Pop-Ups table:


To see this:



Now choose a manufacturer



Choose a Caterpillar product




You can hide Column B.


Regards,

Ian.

Numbers pop up manu

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.