Columns that are dependent on each other without circular reference

Hi guys,

I have two columns of data; one is in inches, one is in metres. If someone is inputting data from an original source that has the data in metres I want excel to automatically calculate and input the data into the inches column. Additionally, if they input the data from the source in inches, I want excel to convert it to metres and input into the other column automatically. The conversion factor from inches to metres is * by 0.0254.
I am no expert but after looking for this on the internet I am sure this requires some sort of VBA event code (although I don't really know the first thing about VBA). The excel columns will be in the same worksheet. Would someone be able to help me with this so I don't have a circular reference like I would do using normal Excel formula? I am using Excel 2010.

Hi,

Welcome to the Forum.

This might be an alternate way, I have created 2 output columns based on the chosen input type in the attached file. Please see if it suits your requirement

Thanks for your quick response.

Unfortunately this is quite a large excel sheet with a pivot table and further formulae relying on the data. If I use the method that you have described, with every change of the input type, the other cells using the metres/inches cells will change due to the formula dependencies.