Imagine this scenario: There are 120 CSV files in a folder on your network. Each CSV export contains the transactions for a single month, and there are 10 years’ worth of files. Your mission, should you choose to accept it, is to combine all of the transactions in these 120 files into a single Excel worksheet. That’s a lot of copy/paste.
Often in Excel, there are multiple ways to accomplish any given task. Some ways are faster than others. Let’s call the copy/paste approach the slow way. The fast way: We can have Excel combine these for us in less than a minute. No formulas. No macros. Just click a few buttons.
The detailed steps to accomplish this are covered in this CalCPA article:
I’ve also put together a short video that demonstrates the steps in Excel:
Hope this helps you get your work done faster 🙂
If you’d like to give it a try, feel free to download the zip file that contains the 120 CSV files: