Q: Want to auto populate a popup menu
Hi! I'm looking for a way to auto populate a popup menu with data from a column on a separate sheet. On Sheet 1 I have a bunch of products names listed in column A (with their prices and taxes in columns B onwards.). On Sheet 2, column A I'd like to select the products required for this particular project from a popup menu (dropdown menu) that includes all the products listed on Sheet 1, column A.
I have quite a lot of products listed in Sheet 1, column A so it isn't practical to enter each into the popup menu manually. I also need to add more products to Sheet 1, column A quite regularly, so need this to automatically update. I can't for the life of me figure it out. Any help would be very, very appreciated.
I'm using Numbers 3.6.2 for Mac.
Posted on Sep 7, 2016 10:52 AM
Hi Liz,
We don't have the feature of auto populating popups at this time. That is, we don't have popups that will refresh when a column is revised.
It may be that you are working harder than you need to to populate your popups. If you have a column of items, select it and change the format to "popup" each of those cells is a popup with all the values of your column. You can copy/paste one of these to your other sheet and use it there.
A while back I was developing an applescript to automate this process but it is still a process that needs to be run- it does not initiate itself. Let me know if you have an interest and I will see if I can dig it up.
quinn
Posted on Sep 7, 2016 3:36 PM