Macros & Excel VBA

How to Remove First Character in Excel (6 Quick Ways)

Here we’ve got a dataset with the Names of some students and their Student IDs of any class. We need to remove the first character (the ‘S’) from ...

How to Use Macro to Delete Rows Based on Criteria in Excel (5 Methods)

In this article, we will demonstrate five effective approaches to using a macro to delete rows based on various criteria in Excel. We'll use the ...

How to Auto Update Current Time in Excel (3 Easy Ways)

  Method 1 - Using the NOW Function  Steps: Select cell C4 and enter this formula: =NOW() Press Enter. It will enter ...

How to Create a Custom Formula in Excel (2 Practical Examples)

Despite all the built-in functions provided by Excel, we may need to create a different function to get our job done. Excel lets us create our own ...

How to Merge Cells Vertically Without Losing Data in Excel

To demonstrate our methods of merging cells vertically without losing data, we'll use the following dataset of some Book Records, and merge the books ...

How to Transpose Rows to Columns in Excel (7 Quick Methods)

Below is a dataset that shows the year and Results of Students. Method 1 – Using Paste Special Command a) Pasting a Special Command from ...

Excel VBA to Copy Multiple Sheets to New Workbook

Copying multiple sheets from one workbook to another manually is prone to errors and can become tedious with lots of sheets. In this article, we will ...

How to Insert Rows Automatically in Excel (4 Ways)

The dataset below contains the names, Regions, and Ranks of some sales representatives. We need to insert rows into the dataset automatically. ...

How to Concatenate String and Integer with VBA (5 Easy Ways)

Let’s consider the Employee Information dataset shown in the B4:E10 cells which contains the “First Name”, “Last Name”, “Country Code” and “Area ...

How to Concatenate Range in Excel (5 Useful Methods)

We’ve got a dataset with the Product ID and Product Name of some products of a company named Mars Group. The values are stored in the Cell range ...

How to Create Multi Select ListBox in Excel (With Easy Steps)

  Step 1 - Creating an Excel Table from a Dataset Create a dataset with the information of 10 City Names and their Total Population on a ...

How to Create Multiple Dependent Drop Down Lists with Excel VBA – 3 Methods

What Are Dependent Drop Down Lists in Excel? Using a dependent drop-down list, you can change the value of a drop-down list and it will show the ...

How to Enter Sequential Dates Across Multiple Sheets in Excel

What are Sequential Dates? Sequential dates are a series of dates that follow a specific interval. For instance, if you have dates like January 1, ...

How to Make Multiple Selection from Drop Down List in Excel

We'll use a simple dataset to create a multi-selection drop-down. Method 1 - Making Multiple Selections from an Excel Drop-Down List with ...

7 Effective Methods to Transfer Data from One Sheet to Another in Excel Using Macros

Method 1 - Transfer Data from One Sheet to Another Using Range. Copy Method in Excel VBA Steps: Hold the Alt + F11 keys in Excel, which opens ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo