Forum Discussion
Marcus750
Mar 11, 2023Copper Contributor
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 tha...
Patrick2788
Mar 11, 2023Silver Contributor
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.