From many years I have been working on VBA based automation projects using Excel, Outlook, Word, Access and other technologies. As a professional developer it was my responsibility to test the tools with all possible scenarios and data. Proper testing of the tools helps to deliver bug free and quality tools to clients.
If you are also a programmer and developing a tool or application. You should always test your tool with all possible scenarios that may come in production environment.
It is always good to test your tool or application with dummy data that is similar to production environment. Creating a dummy data is a big and time consuming task. You need to ensure that your dummy data contains variety of data types and available in massive quantity.
Step 1: Download and save the following attachment in you system
Step 2: Unzip the file and open
Step 3: As the file contains macros, you may be asked to enable the macros to use the tool
Step 4: Click on ‘Generate Dummy Data’ button
Step 5: The form gets loaded with default fields. You may want to add more fields or delete unwanted fields
Step 6: Once you are ready with the fields, click on ‘Generate Random Data’ button on the form
Step 7: Within few seconds, tool will generate the data in a new workbook
Step 8: Congratulations you are now ready to use the tool
This step-by-step guide will show you how to easily do mail merge in Word using an Excel sheet.
Mail Merge can save you a lot of time when you need to send letters or emails to many people. It helps you create personalized letters, emails, or labels in Word by combining the information from your Excel sheet. This guide gives an overview of the main steps and explains how to do a mail merge from Excel in an easy way
Random Rows Selector is an MS Excel based tool which can be used to pick random or stratified samples from a set of records available in Excel.
VBA Code To Change Cell Color Excel supports more than 16 million colors in a cell; hence you should know how to set the exact color in a cell. To do this, you can use…
VBA Code to Find Last used Column or Row in Excel Sometimes as a developer, you need to take actions in Excel sheets based on last row or column. In Excel, there are two kinds…
Excel Add-in helps you to extend the features of Excel application. Using Excel Add-in, you can perform custom actions in Excel such as formatting the data, doing complex calculations which are not possible through Excel formulas, Reading or Writing data in other Excel files and so many more actions.
Table of Content Introduction Create a Detailed Work Allocation Template Define Case Types, Users and Status Configure Dropdowns in the Template Allocate Tasks Based on Skillsets Track Progress with Pivot Table Implement Conditional Formatting Regularly…