Advanced Excel Techniques Excel VBA and Macros

Dummy Data Generator Tool

Table of Content

About the tool

Dummy Data Generator is an MS Excel based tool which has capability of generating 45 types of data which includes numbers, text, date, time, Memo (long text), Booleans etc.

Tool Features

Generate unlimited dummy records on one click
Supports 45 types of data points
Capability to generate Numbers, Text, Date, Time, Long Text, Boolean and many more data types

Benefits

No additional software / investment required, works with commonly available Office Applications
Helps in tool testing
Helps in identifying bugs and deliver high quality tools

System Requirements

You need to have installed version of MS Excel 2010 or above

Tool Limitations

As the number of records increases, tool may take more time to generate random data

How to use this tool

Follow the below video which details out how to use this tool.

Open the tool and you will see below screen
As the file contains macros, you may be asked to enable the macros to use the tool
Click on ‘Generate Dummy Data’ button
The form gets loaded with default fields. You may want to add more fields or delete unwanted fields
Following are the datatype which are available in the tool for selection

Once you are ready with the fields, click on ‘Generate Random Data’ button on the form

Within few seconds, tool will generate the data in a new workbook

Congratulations you are now ready to use the tool

Recommended Articles

VBA Code to Delete File

Excel VBA and Macros | Productivity and Automation

VBA Code to Delete File

Byexcelsirji

In this article we are going to show you how you can delete file or files using a single line of VBA code. 1. Delete a specific file from the folder, 2. Delete specific type of files from the folder, 3. Delete all files from the folder

VBA Code to List Files in Folder

Productivity and Automation | Advanced Excel Techniques | Excel VBA and Macros

VBA Code to List Files in Folder

Byexcelsirji

VBA Code to list Files in Folder To work on multiple files through VBA programming, you need to have VBA code that can list files in a folder. In this article we will learn three…

VBA Code to Filter Data in Excel

Excel VBA and Macros | Productivity and Automation

VBA Code to Filter Data in Excel

Byexcelsirji

VBA Code to Filter Data in Excel Here is an easy reference code which filters data in the sheet. In the code, we have filtered the data in three steps. Step 1: Remove existing filter from…

Excel Nested IF statement: examples, best practices and alternatives

Excel Functions | Advanced Excel Techniques | Data Analysis

Excel Nested IF statement: examples, best practices and alternatives

BySumit Shrimal

This guide shows how to use the nested IF function in Excel to check several conditions. You will also learn about other functions that can be to use than a nested formula.
When you want to make decisions in Excel, you often use an IF formula. It checks if something is true, then gives one result if it is and another result if it isn’t. If you need to check more than one thing, you can put many IFs inside each other.
Although using multiple IFs is common, it’s not the only way to check several conditions in Excel. This guide will introduce you to some easier and useful alternatives.

VBA Code to Sort Data

Excel VBA and Macros | Productivity and Automation

VBA Code to Sort Data

Byexcelsirji

VBA Code to Sort Data HERE IS A ONE LINE CODE FOR DEVELOPER’S REFERENCE WHICH CAN BE USED TO SORT DATA ‘Sort data in ascending order on Column F (Created At) Sheet1.Range(“A1:G” & Sheet1.Cells.SpecialCells(xlCellTypeLastCell).Row).Sort Key1:=Sheet1.Range(“F1”),…

VBA Code to Change Sheet Color

Excel VBA and Macros | Productivity and Automation

VBA Code to Change Sheet Color

Byexcelsirji

What is the Usage of sheet color in Excel? When we prepare a report or a dashboard it is easy to identify or analyze reports with a change of color sheet tabs. Analysts generally give…

Leave a Reply Cancel reply

Excel VBA Master Tool Kit