Excel macro to combine multiple CSV files (with Excel VBA)

Feb 4, 2021 | Excel, VBA

In this Excel automation tutorial, I will show you how we can write a macro (using Excel VBA) to combine multiple CSV files. Imaging your boss asks you to combine 10 or 50 CSV files by the end of the day, and you only have couple hours left. If you are going to do...

Excel VBA Macro to Combine Worksheets in Excel

Nov 23, 2020 | Excel, VBA

IF you use Microsoft Excel a lot, especially at work, it’s a huge pain to combine multiple worksheets into a single master worksheet. Good thing we can automate just about any Excel work with VBA (aka Excel Macro). In this Excel tutorial, I will be sharing a VBA...