Macros & Excel VBA

How to Remove Duplicates in Excel Using VBA (3 Quick Methods)

One of the most important activities in Excel is to remove duplicates from a given data set. Today I’ll show how to remove duplicates in Excel using ...

How to Concatenate String and Integer using VBA

In our daily use of Excel, we face situations where concatenating strings and integers becomes a necessity. In these articles, we showed ways of ...

How to Combine Rows into One Cell in Excel

Today I will be showing how to combine rows into one cell in Excel. While working in Excel, trying to combine rows or columns is one of the most ...

How to Concatenate Range in Excel (For Both Old and New Versions)

One of the most important features of Excel is to concatenate the values from all the cells of a range into a single cell. Today I will be showing ...

How to Create Multi Select Listbox in Excel

Up till now, we know how to create drop-down lists in Excel. Today I will be showing a little more trick, how to create a multi select listbox in ...

Multiple Dependent Drop-Down List Excel VBA (3 Ways)

Creating a multiple dependent drop-down has always been a challenge in MS Excel. We need this kind of drop-down list when there is a dependency or ...

How to Enter Sequential Dates Across Multiple Sheets in Excel

Today I will be showing how to enter sequential dates across multiple sheets in Excel. Up till now, we have learned to enter dates in Excel. We ...

How to Make Multiple Selection from Drop Down List in Excel (3 Ways)

Depending on the circumstances you may need to select multiple values within a drop-down list. In this tutorial, we are going to show you how to make ...

How to Transfer Data from One Sheet to another in Excel Using Macros

For different purposes, we may need to move or transfer data from one worksheet to another in Excel. Doing it manually or with formulas may lead to ...

How to Create Drop Down List in Excel with Multiple Selections

Up till now, we looked at how to create drop-down lists in Excel. Today I will be showing how to create a drop-down list with multiple selections in ...

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 VBA VLOOKUP 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 Quick 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 ...

ExcelDemy
Logo