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...
May 24, 2020 | Excel, VBA
One of the biggest drawbacks with cell drop-down in Excel is the limitation of functionalities you can implement. For example, unless you are a Microsoft 365 subscribers, it is pretty difficult to implement the search functionality, as well as, increasing the...
Apr 22, 2020 | Excel, VBA
In this tutorial, we are going to write a macro using VBA, to export multiple worksheets from an Excel file (let’s call it the master Excel data file) to a new Excel file. Buy Me a Coffee? Your support is much appreciated! PayPal Me:...
Apr 20, 2020 | Excel, VBA
In this tutorial, we will be learning how to create an Excel userform to ease the manual labor of exporting multiple Excel worksheets to individual Excel file. We will be writing VBA to implement various of functions and automations, some experience in writing macros...
Apr 14, 2020 | Excel, VBA
In this Excel VBA tutorial, we will be creating a User-Defined Function (aka UDF) to validate if IP addresses are valid. Assuming you have a spreadsheets with a list of IP addresses, and your job is to validate whether each IP address is valid. My personal experience...