Ive made a series of cash flow sheets on Numbers. Each sheet is another month. I want to copy the ending value of each month to the beginning value of the next month(sheet). In the end, I want any change in a monthly spreadsheet to automatically ripple through all of the sheets.
iMac (2017 – 2020)
If you're going to do this only once then a manual approach is the simplest.
In the next month, select the cell that will receive the amount from the previous month and type =. Then select the previous month's sheet and click on the cell whose amount will be carried over, and press Enter. Repeat for every month.
If you're going to do this only once then a manual approach is the simplest.
In the next month, select the cell that will receive the amount from the previous month and type =. Then select the previous month's sheet and click on the cell whose amount will be carried over, and press Enter. Repeat for every month.
Your answer was spot-on. The whole system works perfectly. Many thanks!
Copy a value from one sheet to a cell on another, in Mac Numbers
