Input in cell 1, output in cell 2; input in cell 2, output in cell 1

[sethna2]

Hello,

See attached spreadsheet.

I am trying to create a scenario where I am able to input into cell B3, and output into cell D3 (B3*D2). HOWEVER, I'd also like the ability to input into cell D3 and output into cell B3 (D4/D2). Is this possible? If so, can I do it without macros/VBA. If macros/VBA is needed, can you help? I do not know macros/VBA.

TIA!

[WideBoyDixon]

You need VBA. Right click the sheet name, select "View Code" and paste the following:

Please Login or Register  to view this content.

That will create a formula in B3/D3 as necessary to do the correct calculation.

WBD

[sethna2]

This is perfect! Thank you. One more question--if I had multiple rows of the same, can I do it with the same subroutine?

[WideBoyDixon]

Do you mean it could be B3/D3 and then B4/D4 ... etc.?

WBD

[sethna2]

Do you mean it could be B3/D3 and then B4/D4 ... etc.?

WBD

That is correct.

[WideBoyDixon]

Small changes to the macro then:

Please Login or Register  to view this content.

WBD