Dummy data generator

[Tigerexcel]

I would like to find some way of quickly generating a small list containing 2 to 3 columns, something like:

Book4
	B	C
2	Name	Age
3	Fred	35
4	Jack	47
5	Harry	27
6	Sue	23
7	Ken	37
8	Dave	50
9	Dean	45
10	Vera	39
11	George	36
12	Mike	42
Sheet7

Cell Formulas
Range	Formula
C3:C12	C3	=RANDBETWEEN(20,50)

I'm expecting the solution to be a UDF or Macro as I can't think of a way of using a function which will remember the names mentioned. Ideally I'd like to pick a range eg 10 rows and have the procedure automatically populate the rows.

 

[alansidman]

Maybe this site--> Mockaroo - Random Data Generator and API Mocking Tool | JSON / CSV / SQL / Excel

 

[Tigerexcel]

Thanks Alan, like the fact that you can create your own fields on that site.

 

[Sulprobil]

If you like you could use my test data generator (test input is the output here):

MrExcel_sbGenerateTestData_for_Tigerexcel.xlsm
	A	B
1	Test Input 1	Test Input 2
2	BLITHE	24
3	CAROLINE	47
4	ESTER	45
5	ERON	50
6	BRANT	44
7	ERLAND	44
8	AVEL	34
9	CARLA	41
10	CLARK	37
11	AMALIA	32
12	CHARLEE	45
13	ASTRID	48
Data

German "WAHR" means True - this should auto-translate when you open the file with a US/UK version of Excel:

MrExcel_sbGenerateTestData_for_Tigerexcel.xlsm
	F	G	H	I
1	Test Data Generator		Input 1	Input 2
2
3	Number of test records		12	12
4	Shuffle after generation		WAHR	WAHR
5	Data type
29	Long			1
30		Sum
31		Min
32		Min	1	23
33		Max	3	50
34		MaxRepeat
35	String		1
36		Length
37		Min	A	a
38		Max	Z	z
39		NextTabRepeat
40		NextTabColumn	2	2
41		NextTabItemRepeat	1	1
42		NextTabItemColumn	1	1
43		NextTabGroupColumn	2	2
44		M	1	1
45		F	1	1
46		E	0
Data

The file is stored here. Download, open, and use it at your own risk (but I am using an up-to-date virus scanner):

Dropbox - File Deleted - Simplify your life

www.dropbox.com