I'm trying to steer clear of Excel, despite my sister's nagging, and I've done pretty well to create a Quote and Invoice workbook in Numbers. The problem I am having is working out how to automatically populate and update a pop-over menu.
In Excel, I can choose to create a list based on a range of cells, which is pretty much exactly the function I require. However, in Numbers I can only seem to create plain text items in a pop-up menu and not reference any cells.
For a little bit more info, I have a separate sheet in my workbook that contains item codes, descriptions, and prices. I can reference them normally in the other sheets. I want to be able to select a cell in one sheet and have a list / pop-up menu come up with all the item codes from the other sheet, and have it automatically update if I add a new one.
Is this possible or will I have to switch to that horrid beast Excel?
Best Answer
I had the same sort of problem and with some help from people within the Apple Support community I came up with this solution. Hopefully it will work for you.
This is my list of players in sheet 1. In your case, the Players name would be the item codes.
Here is sheet where I want to information copied to.
The P# corresponds to the number next to the Players name in Sheet 1. If I enter a 1 and a 2 the names are filled in to the column to the left of the box.
This shows the formula required to transfer the players name from sheet 1 to sheet 2.
To take it a step further, when I fill in the Players winnings in Sheet 1 it also fills it in all the "Earnings" cells for that player in Sheet 2 using the formula shown below.
My list of players goes to 300 but the last 20 or so are empty. That way I can still add more names or in your case, item codes, to it.
This may be more complicated than you require but hopefully it helps you.