Can we now maintain popup lists in auto-sortable sheets that displays in another sheet?

Hi exMacEmp,

Maybe this is not what you are after, but If you can select all Pop-Ups at once, it is possible to edit all those Pop-Ups at once. If they are contiguous in the same column or row, it is easy to select them all at once. For example:

Not automatic in Numbers. This requires some user input.

Regards,

Ian.

If your desire is to create a list of data in a column and have pop up menus that automatically include all those items and any new items you add later, it doesn't work like that in Numbers. You can do it in Excel, though.

In Numbers, a pop up menu is a static list. You can create one from a column of data but it will not be not tied to that column of data. If you change an item in the column or sort it or add to it or delete any items or make any other changes, the pop up menu remains unchanged. Also, each cell with a pop up menu is a separate entity with its own pop up menu. Editing a pop up menu in one cell does not change the pop up menu in any other cells that have the "same" pop up menu. With some manual labor you can update pop-up menus to include new items or take away items or to have the list re-sorted, but it is not fun.

Excel uses Data Validation to make their menus. Data validation can be tied to a column of data and the menu will reflect the changes made in that column.