Hi everyone,

This is my first post in this forum and nice to meet you all here.

I am a new learner of vba, so I still have a lot of technical stuff that I am not yet familiar with and you can think of me as a beginner.

The problem that I have with my database or I am trying to solve is that:


Background
- I have a table which contains some data lets say 2 by 2 for the sake of simplicity
- I would like to create a drop down list which contains different units for distance/lengths for example, meters, inches, and the original data table is in meters as a default
- when the user select an option from the drop down list, let's say inches, all the data on the table will convert into inches from meters.

A general overview
Input (one): an option from the drop down list
Process: all the data on the table times a constant value which depends on the input
Output (many): all the data on the table will be converted into different values that correspond to the input

My thoughts
I know there are always different methods to go about it, however, I would like to have a process that involves automatic calculation, for example, the developer only requires to have another worksheetwhich stores all the conversion units which will be used by excel to process the data, rather than having many different result tables for each unit which is manually obtained by timing each data with the constant.

I am not sure whether I have explained it clearly, feel free to ask any questions or provide suggestions that would achieve the same result.

Thanks a lot!

Frank