Forum Discussion
Nancy Sposato
Jan 03, 2018Copper Contributor
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...
Nancy Sposato
Jan 04, 2018Copper Contributor
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.
John Twohig
Jan 04, 2018Iron Contributor
- 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.