VBA for generating units table

[ajaysomasi]

Hi everyone

I'm looking for VBA code to develop a Units table as an output as explained below.. I have a lot of units to organize, hence a code will help solve my problem quickly.. Appreciate your help..

I have units in the following manner:

1 m = 100 cm
1 m = 1000 mm
1 m = 0.001 km

I want a table that lists out the conversion for all possible combinations.. The output for the above input will look like this:

Original unit	Conversion	Target unit
m	100	cm
m	1000	mm
m	0.001	km
cm	0.01	m
cm	10	mm
cm	0.00001	km
mm	0.001	m
mm	0.1	cm
mm	0.000001	km
km	1000	m
km	1000000	mm
km	100000	cm