How do I connect 2 Excel Sheets to give auto answer on the 3rd
What do I do to connect an income sheet and an expense sheet to a third sheet
to automaticly give a running balance |
How do I connect 2 Excel Sheets to give auto answer on the 3rd
If you just need the current balance, you could just do something like
=sum(income!C:C)-sum(expense!C:C), where income and expense are the worksheet names and C is the column in which each amount is posted. If you want to have the history of the balance at each day's end, you'll probably change the SUM functions to SUMIFs, comparing the date on the summary sheet to the dates on the income and expense sheets, getting each day's change and adding it to the prior day's balance. --Bruce "Maca" wrote: What do I do to connect an income sheet and an expense sheet to a third sheet to automaticly give a running balance |
All times are GMT +1. The time now is 06:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com