Macros & Excel VBA

How to Insert Rows Automatically in Excel (3 Ways)

While working in Excel, we may need to insert rows automatically in our dataset. Excel provides some features to do that job. Today, in this article, ...

How to Merge Duplicate Rows in Excel (3 Effective Methods)

While dealing with Microsoft Excel at home and office, at super shops or corporate companies, we often need to assimilate duplicate worksheet rows ...

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 with VBA (5 Ways)

Without a doubt, VBA Macros help to solve various problems and automate repetitive tasks in Microsoft Excel. Now, concatenating strings and integers ...

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

In this regard, When working with dates in Excel, we have learned to enter dates in our various desired orders. Besides, we have learned to enter a ...

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. However, doing it manually or with formulas may ...

How to Create Drop Down List in Excel with Multiple Selections

Until now, we looked at how to create drop-down lists in Excel. Today I will show how to create a drop-down list with multiple selections in Excel. ...

Excel VBA to Find Value in Column (6 Suitable Examples)

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 Excel VBA VLOOKUP to Find Values in Another Worksheet

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

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

ExcelDemy
Logo