You can convert your worksheet data into a table using a macro or without macro. Both the process is simple. However, sometimes we need a small program or a macro to automate a process. ...
I know it must have been very annoying when you saw this project in your VBA. And I am sure you must have scratched your head (like me) for quite some time to remove it, but you couldnt ...
You can use the Mid() function in VBA to split a given string into an Array of characters in Excel. ...
There are various ways to remove or delete blank rows in Excel. Either you can do this using an Excel built-in feature called Go-To Special or you can automate the process using VBA. Here in this post ...
The email body usually contains plain text data, in paragraphs, and you can attach files. You can also send emails from Excel in other formats, like in the form of an HTML Table. I’ll show how ...
Well, its holiday season again and Christmas is approaching, followed by the New Year. Many of us would be preparing to send emails to our colleagues, clients, friends and family. I’ll show you how to ...
You can create charts easily in Excel using data in your worksheet by selecting a range of data and then insert a chart. Or, you can automate the process of creating beautiful interactive charts with ...
Let us assume I have a word file with few paragraphs in it. I want to copy content as it is from the doc file and write it in my Excel worksheet, each word in a cell, go to the next line or row and ...
An alphanumeric value in an Excel cell may look like this “70 kg” (a number and two alphabets). Now, let us assume, I have two cells with values 70 kg and Rs. 50. How do I calculate these alphanumeric ...
Let us assume, I have sales data in my Excel worksheet for two or more consecutive years (for certain products), which I collect from different regions. I want to know the percent change in sales fig ...
