You could have observed that when we get a list of items by using the filter in tables, if they contain any serial number, they will not adjust, but we can make them in order by using the vba code; this can't be completed using the default operations provided by Excel. Read this tutorial to learn how you can auto-number or renumber after a filter in Excel. AutoNumber or Renumber after Filter Here we will insert a VBA module and then run it to complete our task. Let us see a simple process to understand how we can auto-number or ... Read More

When we try to insert a sequence number into an item in Excel, we always use the autofill handle, but when we try to apply the same process to cells of different sizes, the error appears. This process can’t be completed using the default functions in Excel; instead, we will be using the VBA application to complete our process. Read this tutorial to learn how you can autonumber merged cells in Excel. AutoNumber Merged Cells in Excel Here, we will first insert a VBA module and then run the module to complete our task. Let us see a simple process ... Read More

Have you ever tried to create a list of numbers in Excel? It is a very simple process, and there are many ways to do it. Generally, this kind of list is generated to assign the serial numbers to the list and also count the number of rows we used. Read this to learn the different ways to auto-number a column in Excel. In this tutorial, we will look at three different methods for creating a series: the row function, the offset function, and simply using the auto-fill handle. Auto-Number a Column Using the Row function Here we will ... Read More

You could have tried to auto number a column based on other column only based on uniqueness of the cell values but have you ever tried to auto number a column based on cell value on another column. This article will help you to understand how we can auto number a column based on cell values on other columns in excel. Let us consider a situation where you want to count the no of items in a list excluding a single repeated and you don’t want to delete the item. This tutorial will help you to solve these kinds of ... Read More

Sending a report from Excel could be a time-consuming and inefficient process if we do it manually. We can automate this process by following the steps below before sending the email. This tutorial will help you understand how we can automatically send email based on cell values in Excel. When the value of the mentioned value follows the condition, then the email application will be opened. Automatically Send Email Based on Cell Value Here we will insert VBA code for the worksheet, then open the email application. Let us see an effortless process to see how we can automatically send ... Read More

When we save the Excel workbook in shared memory, if one person accesses the sheet, other people will be unable to save the sheet; this problem can be solved by automatically closing the sheet after a certain amount of time. This tutorial will help you understand how we can automatically save and close an Excel file after a certain idle time. Automatically Save and Close an Excel File after a Certain Idle Time Here we will first insert VBA code for the sheet, then create a VBA module, then run it to complete our task. Let us see a straightforward ... Read More

We need to run a macro by going to the Developer menu and selecting Run Macro or by using the shortcut we created. But have you ever tried to run a macro based on a cell value? It can be done by using the VBA application. In this process, we will automatically run the macro when the value of the specified range has changed. This tutorial will help you understand how we can automatically run macros when the result of a cell formula changes. Here, we will first select the range of cells and then insert the VBA code for ... Read More

When we use the text boxes in Excel, you may have observed that manually resizing the text boxes to fit the content is one of the most time-consuming processes, as adjusting them could be a slower process. This can waste a significant amount of time when doing the Excel work. This tutorial will help you understand how we can automatically resize the text box to fit the content in Excel. We can do it with the help of a VBA application, as it cannot be done by default in Excel. Automatically Resize a Textbox to Fit the Content in Excel ... Read More

When working with a list of data, it is especially important that there are no duplicate values in Excel. The values that are repeated in the list are known as duplicate values. This tutorial will help you understand how we can automatically remove duplicates from a list in Excel. Duplicates can lead to the wrong analysis and rechecking of data. We can do this process with the help of data validation in Excel. Automatically Remove Duplicates Form a List in Excel Here we will first create a data validation list using the formula, then edit the error message. Let us ... Read More

One of the more difficult processes in Excel is creating and comprehending pivot tables. When we need to add the new data to the pivot table, we need to add the data to the source data and create a new table. This can waste a lot of time analysing the data in Excel. This tutorial will help you understand how we can automatically refresh a pivot table in Excel. The pivot table is used to understand the tables in a clearer way and help us analyse them more quickly. Automatically Refresh a Pivot Table in Excel Here, we will first ... Read More