Macros & Excel VBA Archives

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

Sep 23, 2021 Excel Functions

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

Sep 23, 2021 Excel Formulas

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)

Sep 23, 2021 Excel Formulas

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)

Sep 23, 2021 Excel Power Query

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)

Sep 22, 2021 Excel Formulas

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

Sep 22, 2021 Excel Formulas

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)

Sep 22, 2021 Excel Functions

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)

Sep 22, 2021 Excel Functions

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)

Sep 22, 2021 Macros & Excel VBA

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)

Sep 22, 2021 Excel Functions

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)

Sep 22, 2021 Excel Functions

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)

Sep 21, 2021 Excel Formulas

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)

Sep 21, 2021 Macros & Excel VBA

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]

Sep 20, 2021 Excel Basics

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)

Sep 20, 2021 Excel Formulas

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