Excel Archives - Learn Data Analysis

Source Code: How to combine Excel worksheets using Excel VBA (Excel Macro)

Apr 6, 2021 | Excel, PyQt5, VBA

Buy Me a Coffee? Your support is much appreciated! PayPal Me: https://www.paypal.me/jiejenn/5 Venmo: @Jie-Jenn Source Code: Const MasterSheetName As String = “Movie List” Sub Combine_Movie_List() Dim wsMaster As Worksheet, ws As Worksheet Dim...

Create an Excel Data Entry Form in Excel Source Code

Feb 24, 2021 | Excel, VBA

In this Excel tutorial, I will be showing you how to create an Excel Data Entry Form Template from scratch using the built-in the built-in Userform editor. (The tutorial will be involving writing VBA code, but I will walk you through everything). Why build you own...

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...

Create a Macro To Spit a CSV File Into Multiple CSV Files with Excel VBA

Dec 6, 2020 | Excel, VBA

In this video, I will be showing how to write a macro to split a CSV file into multiple CSV files using Excel VBA. Splitting a CSV file or an Excel file is probably one of the most common tasks in work places, and instead of manually doing it by hand to waste...

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...

Replace drop-down by building a Userform in Excel | Full Tutorial

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...