Calculate value based on another cell and vice versa

[Dr_agnes]

Hi everyone,
I've run into a problem with a project i'm working on. I have column H = cost of item, I = sales price, J = earnings in percentage. What I'd like to do is autofill I or J based on the value of the other one. I've made a partial code, but i've hit a wall (I only do this on a hobby level). I also might be completely off base. Any input is greatly appreciated. Thank you.

Please Login or Register  to view this content.

[jolivanes]

Do I understand you right that you want to calculate column I if you enter a value in Column H and calculate Column H if you enter a value in Column I? Never a need of Column J to be calculated?

[Dr_agnes]

No, sorry if i didn't make it clear. H is what it'll cost me to buy an item. I want to calculate I based on an entered value in J and vice versa. In that way i can enter what i wish to sell it for (I) and i see the percentage earned from said item (J), or I can set how big an earning i want (J) and it'll give me the sales price (I). So H never need to be calculated since it's the price from the supplier. Thank you for your response.

[jolivanes]

Try so.
Change references as required.
Code assumes you have headers in the top row.
Column J is Formatted as percentage.

Please Login or Register  to view this content.

[jolivanes]

I have changed the code in Post #4. It also has some error trapping now.

[Dr_agnes]

Perfect! Thank you so much!

[beyond Excel]

This is one way to do it:

Please Login or Register  to view this content.