Solutions

How to Merge Multiple Workbooks to One Workbook via Excel VBA

When you need to collect information from other people, you will receive multiple Excel workbooks. And in this article, we will introduce the methods to merge multiple workbooks by using Excel macro. When you have received multiple workbooks, you will find it hard to manage those files. All the information is separate in those different files. In the image below, you can see that there are several workbooks. In each file, there are the sales volumes of this month. Now you need to input...

Read more »

2 Methods to Link Tasks with an Appointment in Outlook

Many users have the wish to link several tasks with an appointment in Outlook. In this article, we will focus on this issue and introduce 2 approaches. Sometimes, we indeed hope to associate task with appointment in Outlook. For example, we have an important appointment in our Outlook calendar. Before the appointment, we need to do some additional preparations. So we create several individual tasks for this appointment. At this point, we must wish to link these items. In response to this...

Read more »

2 Quick Ways to Select Texts with Similar or Same Formatting in Your Word Document

In this article, we will propose you 2 quick ways to select texts with similar or same formatting in your Word document. Selecting texts is a vital part in document processing. And our need to select texts varies from scenario to scenario. So today, we come to the topic of selecting texts with same or similar formatting. First, let’s see when you are going to employ such a skill. Following are 2 situations: To check whether a text is set in correct formatting. There can be...

Read more »