Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language VBA helps to automate many functions which increase your productivity in work and save a lots of time if u get irritated by doing same work in excel sheet . if you doing same repetitive process daily. give so much time in that process.Then you need learn VBA. I feel bored doing office work , so much repetitive process, such as highlight , copy ,paste, data extraction , sometime i hated my work . then i learned VBA in lockdown duration. Now i loved my work and my productivity increase and save a lots of time for example If you want to save each sheet as new workbook, it easy if you have 2-3 worksheet , but if you have 50-60 worksheet then it took lots of time and you get exhausted and you hate your job. if you copy 10-20 workbook data in single sheet and in every workbook data column sequence different. just imagine the time it took...