Forum Discussion
Multiple sheet compilation
Hi all,
I've spent many hours on these forums learning how to use excel a bit
But this is my first time making a post
I'm currently traveling se Asia and have made a budget spreadsheet just that i can see what and where my money has gone
i make two new sheets for each country i visit 1. data entry 2. informative sheet
i would like now to make another sheet to put all the "informative" sheets together
they are NOT all the same and hold different info
INFORMATIVE SHEET
| Total | Per Day | |
| 7 Days | ₭0,000,000 | ₭000,000 |
| Food | ₭000,000 | ₭000,000 |
| Accommodation | ₭000,000 | ₭00,000 |
| Alcohol | ₭000,000 | ₭00,000 |
Above sheet is made with the following formula; =SUMIF(Laos!B3:B,"*"&A3&"*",Laos!C3:C)
To try and explain my mess it will search for the word in a3 i.e. food on the data entry sheet column B and return value in C
DATA ENTRY SHEET
| Sat, 28 Jan | Accommodation | ₭00,000 |
| Food | ₭00,000 | |
| Alcohol | ₭00,000 |
i now have about 8 Informative sheets all some with different categories and would like to combine into one sheet
- Depending on the version of Excel, you could use VSTACK to consolidate and a few other functions to summarize. Before drawing up a formula this project begs the question: If the 8 informative sheets contain similar types of data, why are they split across 8 sheets? You could maintain them in one sheet and add a column for country. You could then use SUMIFS or a pivot table to summarize.
