Solutions

How to Run VBA Code in Your Excel

VBA is an excellent tool in Microsoft Office suite, including MS Excel application. It can assist you to accomplish a lot of tasks not supported by the native features in Excel. Now, in this article, we will teach you to run VBA code in Excel step by step. If you intend to write some VBA codes to achieve some of your requirements, you have to firstly figure out how to run VBA code in your Excel. Now, thereinafter, we will use MS Excel 2010 for an instance to show the detailed steps,...

Read more »

How to Batch Export the Business Card Images of Multiple Outlook Contacts to a Windows Folder

Outlook doesn't offer a direct feature supporting you to export a contact's business card image, not to mention batch exporting multiple business card images. But, in this article, we will uncover a piece of VBA code, which can realize it with ease. It is easy to export the contacts from your Outlook to a local folder as text files or vCard files. Yet, at times, you may want to save the contacts' business card images to the local folder. However, there is not such a native feature for this....

Read more »

2 Easy Ways to Consolidate Rows in Your Excel

When analyzing the data in Excel, you may find it contains multiple duplicate rows. In this case, perhaps you'll want to quickly consolidate the rows. This post will offer 2 quick means to get it. Many users frequently need to merge the duplicate rows and sum the according values in Excel. For instance, I have a range of data in an Excel worksheet which contains a plenty of duplicate entries, like the following screenshot. Hence, I wish to consolidate the duplicate rows and sum the...

Read more »