Have you ever tried to get the values of an object using a drop-down list so that the value represented in the cell is based on the value we select from the drop-down list? This can be done using the process mentioned in this article. Read this tutorial to learn ... Read More

Let us assume we have a situation where we want to know the date of the last update of a value in a list, and you want to record the date of the last update. This process can be done using the VBA application, as it cannot be completed directly ... Read More

In Excel, we can get the sequence of numbers by using the auto-fill handle if there are no conditions. But have you ever tried to auto-number the cells by ignoring the blank cells in Excel? This tutorial will help you understand how we can auto-number rows if adjacent cells are ... Read More

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