Formula and data entry in same cell

Hi,

Can anyone help me with this:

I want to be able to have a formula for cell A1 which would be B1+constant and
a formula for cell B1 which would be A1+constant

both cells A1 and B1 must have the formulas but manual data input must be possible in them which means if I change A1, B1 changes and vice versa without the formula getting deleted.

Also I want to extend this to row 1 to 5 in column A and B.

Can anyone please help!

Thanks

Circular reference issue. Avoid doing such a thing. Use a helper cell.

Hi,

Yes I understand, but is it not possible with VBA?

Thanks

Maybe possible but not a good idea. What are you trying to accomplish? Perhaps attach the file with some sample data.

Something like having two columns one with entry of weight in Kg and the other with entry in lbs and allowing the user to enter in any column and make the other column automatically update.

You will need a data table for reference. Then use lookup or index/match to get your desired results.

Select a blank cell next to your pounds data, and type this formula =CONVERT(A2,"lbm","kg") into it, and press Enter key, then drag the autofill handle down to the range cells you need.

This is provided the weights are in column A for lbs.

=CONVERT(1, "lbm", "kg")
=CONVERT(1, "kg", "lbm")

Sorry duplicate

It would not let me post an html so here is the file example:

Thanks for your efforts, really appreciate it, but I am looking for something different.

I want to have two column one for weight in pounds and the other for weight input in kgs and the user to be able to enter into anyone column (kg or pound) and the other column (kg or pound) to automatically update. A little complicated but am working with VBA on it.