Liz8

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

Close

Q: Want to auto populate a popup menu

  • All replies
  • Helpful answers

  • by t quinn,Solvedanswer

    t quinn t quinn Sep 7, 2016 3:36 PM in response to Liz8
    Level 5 (4,995 points)
    Mac OS X
    Sep 7, 2016 3:36 PM in response to Liz8

    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

  • by Liz8,

    Liz8 Liz8 Sep 7, 2016 3:38 PM in response to t quinn
    Level 1 (4 points)
    iWork
    Sep 7, 2016 3:38 PM in response to t quinn

    Hi Quinn

    Your tip worked perfectly for what I need—thanks! I just need to be careful not to accidentally change the selected popup in Sheet 1, which seems like it might be easy to do. So I'd still prefer the non-existent method to exist! But this will work for now!

    Liz

  • by t quinn,

    t quinn t quinn Sep 7, 2016 3:41 PM in response to Liz8
    Level 5 (4,995 points)
    Mac OS X
    Sep 7, 2016 3:41 PM in response to Liz8

    Hi Liz,

     

    Glad that has you covered. FYI- after you copy your popup you can revert the column back to text to discourage unintentional edits.

     

    quinn