How to copy data from one cell to a cell in a second sheet in Numbers.

Modifying a pop-up menu list, or creating a new one, is quite simple in Numbers.

For a new list:

In a single column, list the menu items, one to a row.

When the list is complete:

• Click once on the cell containing the first entry to select that cell.
• Press and hold shift, and click on the cell containing the last entry to add that cell and all cells between it and the first entry cell to the selection.

With all of these cells selected:

• Click the Format button to open the Format Inspector, then click Cell to select the Cell format pane.
• Click on the Data format pop-up to open the list of formats and choose Pop-up List.
• Then click on "Stone'art with blank to add a choice labelled 'none' This will create a 'blank' cell when selected.

Each of the selected cells now contains a copy of the same pop-up menu, set to display the original value entered in that cell.

Select any one of the cells, set its menu to 'none'.

You now have a cell that contains the full list and is set to display a blank cell. With that cell still selected, press command-C to Copy.

Now go to the table where this menu is to be used, Select all of the cells in the column where you want it installed, and press command-V to paste a copy of the pop-up menu into each of the selected cells.

Regards,

Barry

You'll find an example of how to do this in the Personal Budget template included in the templates provided with Numbers.

File menu > New from Template Chooser

If you do not see this choice at the top of the menu, press and hold Option to make it appear.

This template also demonstrates a guiding principal in designing spreadsheet documents—as much as possible, keep your Data entries and the summary calculations separated. All entries in Personal Budget are made on the Transactions table; all calculations are done in the Summary by Category table on a separate sheet.

Regards,

Barry