Automated entry in one field to change values in another instead of manual entry

Wow...sorry for that cryptic title but I wasn't sure how to explain it any shorter (not that that explains it very well!)

Anyway...I'm going to explain this as simply as possible:

I need to make cell A1 = cell D1. Cell A1 is calculated by entering a number in cell E1. Due to the various formulas used, when cell E1 goes up, the value in cell A1 goes down (and vice-versa - When E1 goes down, value in A1 goes up). Cell D1 is calculated using formulas UNASSOCIATED with A1 or E1.

I can't enter a formula for cell E1 to do the calculating due to the circular reference created.

I need some type of code that will automatically figure out what number needs to be in cell E1 to make cell A1 equal Cell D1 without creating the circular reference.

Thanks!

Originally Posted by Josiah

Wow...sorry for that cryptic title but I wasn't sure how to explain it any shorter (not that that explains it very well!)

Anyway...I'm going to explain this as simply as possible:

I need to make cell A1 = cell D1. Cell A1 is calculated by entering a number in cell E1. Due to the various formulas used, when cell E1 goes up, the value in cell A1 goes down (and vice-versa - When E1 goes down, value in A1 goes up). Cell D1 is calculated using formulas UNASSOCIATED with A1 or E1.

I can't enter a formula for cell E1 to do the calculating due to the circular reference created.

I need some type of code that will automatically figure out what number needs to be in cell E1 to make cell A1 equal Cell D1 without creating the circular reference.

Thanks!

Hi,

Can you zip and add the workbook here. If you're getting a circular reference with the cells you mention, then clearly D1 IS associated in some way, directly or more likely indirectly with A1 & E1.

Have you tried the Solver tool?

Rgds

See if this helps. (FYI The cell examples I provided in my original post were not the actual cells involved in the sheet)

??????????????????

Can anyone help????

Thanks







...
..