Forum Discussion
excel formular help
I use excel spread sheet to help with my checking account. I need help with formula. Each sheet is a different year. How do I bring ending balance from last year to beginning balance for this year. T...
Willy, I'm sorry I think you are making it more complicated hen I needs
to be. I have 2 sheets and I want to bring over the ending number from
one sheet over to the new sheet.
- Click in the cell where you want the beginning balance on the new year page
- Press =
- Click on the tab for last year
- Click in the cell that has last year's ending balance
- Press Enter
If it is only once a year you probably don't need to do anything more complicated than that.
- Nancy,
bying following John's solution, you can see the formula in the cell where you want the beginning balance on the new year page. Next year, you can change the worksheet name, and the row number.