In this article, we will create a macro to insert page breaks, based on a certain condition. Raw data consists agent wise data, which includes Agent name, Client name, Phone number and Email id. We want data … Continue reading
In this article, we will create a macro to insert page breaks, based on a certain condition. Raw data consists agent wise data, which includes Agent name, Client name, Phone number and Email id. We want data … Continue reading
The macros below can be used to replace text in a text file, e.g. when you want to change a column separator in a text file before you import it into an Excel worksheet or after you export a worksheet … Continue reading
In this article, we will create a macro to arrange data day-wise on multiple sheets. Raw data for this article consists day-wise sales data of the team, which includes Date, Agent Name and Number of items sold. We want … Continue reading
