Macros & Excel VBA

How to Find Value in Column Using VBA in Excel (4 Ways)

In MS Excel we frequently need to search or find values in the dataset. It could be finding data in the rows or the column. Fortunately, Excel ...

Use of VLOOKUP in VBA to Find Values from Another Worksheet in Excel

Circumstances may arise when you need to use certain VBA codes that execute the operation from different worksheets, like you may need to use VLOOKUP ...

How to Use VLOOKUP in VBA (4 Ways)

In terms of searching or seeing some specific values or elements, MS Excel provides various functions. VLOOKUP is one of them. It helps us to search ...

How to Pull Data from Multiple Worksheets in Excel (4 Ways)

While working in Excel, we often have to work with a lot of worksheets in a workbook. Today I will be showing how you can pull data from multiple ...

Random Sort in Excel (Formulas + VBA)

MS Excel provides a few different sorting choices on top of the usual ascending and descending orders. We also have sorted by color or icon, as well ...

How to Sort Multiple Columns in Excel Independently of Each Other

In Microsoft Excel, there are a lot of ways to arrange text data alphabetically, dates chronologically, and numbers from smallest to largest or from ...

How to use VBA DIR function in Excel (7 Examples)

Excel provides several VBA functions that can be used while writing a macro or to define your own function to perform your desired tasks. In this ...

How to use VBA UCASE function in Excel (4 Examples)

Excel provides several VBA functions that can be used while writing a macro or to define your own function to perform your desired tasks. In this ...

How to Use InStr Function in VBA (3 Examples)

While working with Excel VBA codes, we come across few built-in functions that convert a complex task into a small one-line code. InStr is such a ...

How to Use LCase Function in VBA in Excel (With 4 Examples)

When working in VBA, we often need to convert certain strings into lowercase, uppercase, or proper case strings. In this article, we will talk about ...

How to use VBA SPLIT function in Excel (5 Examples)

Excel provides several VBA functions that can be used while writing a macro or to define your own function to perform your desired tasks. In this ...

How to Use INT Function in Excel (With 8 Examples)

When you have a decimal number in your dataset, you can use the INT function to get the nearest integer. This article will discuss the INT ...

Dynamic Advanced Filter Excel (VBA & Macro)

Circumstances may demand different types of filter operations; advanced, dynamic, and so on. Our agenda for today is to show you how to use the ...

How to Apply Multiple Filters in Excel [Methods + VBA]

Filtering becomes indispensable when you have a larger and complicated dataset. Retrieving the desired data is quite time-consuming from such a ...

Excel Sum Last 5 Values in Row (Formula + VBA Code)

We frequently add up a series of numbers, but in certain cases, we may need to sum the last 5 values in a row. In this article, I’ll discuss the ...

ExcelDemy
Logo