Excel VBA for Repetitive Task — Part 1
Among our daily jobs, there are always some repetitive works that you need to spend an hour or two every week. Me and my co-workers have been struggling on these daily/weekly tasks, but I finally built my own macro to solve the issues. Here I would like to share two examples using Excel (or other applications in MS Office Suites) VBA.
Combining multiple Excel spreadsheets into one
Imagine you work for a company as analyst. The ERP system allows you to download shipment detail reports only by MONTH, yet you need a big sheet including the…