Sharing a simple formula in Excel showing how to add days number in sequence quickly. The formula uses the SEQUENCE() function, a new built-in function in Excel. ...
Let us assume, I have multiple tables in my Excel worksheet. I want to email the tables as it is (with color, fonts etc.) as HTML table in the email body. I’ll show you how easily you can do this ...
In this tutorial, I’ll show you how to create and add ActiveX Controls dynamically in a UserForm and save all the data (extracted from the controls) in an SQL Server table. ...
In this post I’ll show you how split text string from one cell to multiple cells. I’ve shared 2 different methods: using a new function called TEXTSPLIT and another using a macro in VBA. In-addition ...
You can insert an image in Excel by simply dragging and dropping it anywhere in your worksheet. Its a floating image, that is, you can drag or move the image anywhere in your worksheet. However, with ...
Well, you can send emails from Excel using Outlook and a simple Macro. No worries if you dont have access to Outlook or for some reason dont want to use Outlook from Excel. You can still send ...
Let us assume, I have a list of values (numbers or alphabets) in one column and each value has 6 digits. I want to mask the first 3 digits with * (asterix) and show the last 3 digits only ...
Let us assume I have an Excel file in a folder and I want to copy data as it is to another file (a master file) using VBA. When I am saying as it is I mean the macro should copy data from sheet to ...
In this tutorial I will show you how to import or extract Outlook emails into a Word document using VBA. Importing emails from Outlook into Word (or Excel) can help you analyze the data ...
Here in this post, I will show you how to create a simple progress bar in Excel using UserForm and VBA ...