New to Numbers. How do I get data from one page to update on another page?
Mac Pro, macOS 12.6
On "another page" (sheet it is called in Numbers), start the formula with =, select the tab of the source sheet and click on the cell providing the data, then hit Enter
Maybe not. If the cells are organized exactly the same way in the tables on both sheets, after typing the first formula grab the yellow bubble that's on the edge of the cell and drag it away from the cell. You can also drag many cells at once like this.
Autofill cells in Numbers on Mac - Apple Support
Hi CHLNGR0144,
From the link posted by Recycleur Autofill cells in Numbers on Mac - Apple Support
Note: To autofill from the Numbers menu bar, select the cells you want to autofill, choose Table > Autofill Cells, then choose an autofill option. Depending on the selected cells, some of the autofill options may not be available.
It is a long time since I used Numbers '09, but from memory, that too had a menu item to Fill.
Or, select and Copy the cell with the formula, select the cells where you want the fill, and Paste.
Regards,
Ian.
I cannot say, I was not using this old version of Numbers.
When you select a cell and a green frame appears around it, then hover the mouse over that cell, doesn't a yellow bubble (or other old visual clue) appear on the closest side and the cursor change to a two-point arrow?
Alas, no. When I select a cell or cells, the border around them is blue. When I hover over that border, the cursor turns into the grabber hand.
I guess I'll see if I can upgrade Numbers on my old Mac.
Thank you!
Do I have to do this for each cell individually?
Thanks again. I got all excited for this, but it doesn't work.
Perhaps because I'm using Numbers 2009
New to Numbers. How do I get data from one page to update on another page?
