Hello Excel wiz
I am beginning to learn how to use excel so please be patient with my query, it is a two fold question.
I am trying to put together a personal financial statement that will pull data from each month and display it on the overview sheet.
Question:
1) Is it possible to consolidate the data by the type of category which then is updated in real time on the table in column "S" ?
2) can the total income and expenditure be automatically pull from sheet "jan", "feb", "mar" and be displayed on the overview sheet?
I have attached the example to this thread, and thank you in advance.
Best.
SelfLearningExcel
Bookmarks