Dynamic Pop-up Menus

Part 1: Is it possible to have a pop-up menu reference a group of cells on a different table? I want the pop-up menu to get populated with the values in the other cells. Let me give you an example:


A1 = Banana

A2 = Orange

A3 = Apple


I would like to have a pop-up menu (on a different sheet) read:

Banana

Orange

Apple


Part 2: If Part 1 was possible, is it also possible to have the pop-up menu update itself automatically? Let's say I add A4 = Pineapple to my table. Could I get my pop-up menu to automatically have "Pineapple" as an option or must I manually type it in as a selection?


Thank you so much for your help. I have tried to find this answer but have had no luck. Have a good day.

MacBook Air, OS X Mavericks (10.9.4)

Posted on Aug 12, 2014 7:51 PM

Reply
33 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Dynamic Pop-up Menus

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