Create numbers drop down using data from a worksheet

Thanks @SG

Yeah, I wasn't sure if someone from Apple monitored these discussion groups. I tried doing the cut and paste into cell drop downs, but it's just too clunky and inflexible without being able to do a dynamic lookup. It's actually pushed me back to using Excel, which is a real shame.

I have already provided Apple feedback (at least a year ago). The silence back on any view of what's in the development plan or future list is deafening.

I guess this was my annual appeal, shouting into the void for some hope again! :)

Thanks for taking the time to reply. Good to know I'm not alone and other people find the feature in Excel and Google Sheets useful.

Thanks for the response Ian.

To clarify, I'm not trying to replicate Excel with a huge sheet of cells and I liked the Numbers approach of small tables organised by purpose.

The issue I was focusing on is the time and effort taken to manually amend a pop-up cell list and add/delete items in the cell, then replicate that cell when using it for data entry.

The ability to look up a table of cells with values and populate dynamically, rather than having to cut/paste into the preferences would be of great value.

I guess it's the introduction of dynamic fomulae reference lookups that can be defined in a setup table is the underlying feature.

I'll take a look at the examples you've suggested. I had managed to do much of that, but the additional manual edit/copy/paste for populating a selection cell whenever data changes, versus being able to add additional data to a named range and having it picked up in a lookup to a selection cell was just too time consuming to use in Numbers.