ajaysomasi
New Member
- Joined
- Mar 6, 2017
- Messages
- 25
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:
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 |