Excel “Previous” Formula

How do you get an Excel spreadsheet to continually reference the previous sheet? I have a Monthly Expense Report workbook and I need each sheet (month) to reference the previous sheets’ ending balance for the current sheets starting balance. I know I could just change the month every time, but each sheet has several departments so, it is a little time consuming. Is there an easier way?

 

Thank you!

YoungAccountant

By: Roxy

Leave a Reply

Your email address will not be published. Required fields are marked *