Project Summary
In our day to day work, we deal with multiple systems, and often this systems are not linked. This brings us in a situation, where we need to extract data from multiple systems and manually process the data on a regular basis. This on one hand is time consuming and also prone to errors. To avoid such situation, its always helpful to automate such mundane tasks with the help of excel VBA solutions. Most of our tasks in the past have involved some degree of data extraction and processing exercise where we consume data from multiple file / DB types like .xlsx, .xls, .csv, .txt, .json, sql etc
