Hello. All my VBA related content on Youtube is accompanied with a Macro File, that you can download from Github. The download link is given in the description for the Youtube video. The objective of this page is to help…

Learn to Lookup any data using the Find function.

Learn how to split a master report into individual files & also, merge separate files into a single report.

Learn to create a large, rule-based dataset with randomized data.

Learn how to cut/ copy entire row of data based on a cell matching a certain condition. 2 Ways: For Loop and Advanced Filter

Learn how to blank out rows with blank cells using 3 Ways: SpecialCells, For Each Loop and For Loop

Learn how to delete blank rows using 2 Ways: SpecialCells and Reverse For Loop

Learn how to find the last row of a dataset in an Excel worksheet using the Find method.

Learn how to find the last row of a dataset in an Excel worksheet using Tables.