Forum Discussion
Combining Excel Files
I have 5 separate spreadsheet files (example below) laid out like this that all need combining. Each file contains different data but the headers in bold are the same. I tried to combine t...
Have you tried the VSTACK function? There are several tutorials online to show you. That might help. Good luck!
I tried this but couldn't work out how this works as my data is displayed vertically across multiple tabs and I will have fresh data every month. Any ideas?