First a question - in your post you have E4 =1800 and E4=4300
4500(H6)-200(E5) = 4300 to place at cell E4
was there a reason for this.
I think that I have managed to construct the set of formulas that you refer to in your response (Response #2)
The formulas do indeed contain a circular reference.
Creating the formulas using a macro (you said All the formula used should be retained.), will not stop them containing a circular reference.
Circular references are not the result of how you create formulas - they are the result of what the formulas refer to.
Are you sure that you want a circular reference.
With a circular reference, when a value that the formula refers to changes, the result of the formula changes and this in turn causes another cell that the formula refers to, to change. This causes the result of the formula to change and again this causes that cell that the formula refers to, to change.
As a result the change in the formula is endless, although the changes may get increasingly small.
I believe that it is possible to limit the number of repeated re-calculations that Excel performs, so that the loop is not endless.
Limiting recalculation will affect all calculations in your workbook and may result in different results for some formulas, elsewhere in your Workbook. The results for the cells that are in the loop of the circular formula will have results that are affected by the limitation in the number of times Excel goes round the loop, recalculating the formulas.
a. Is this what you really want.
b. Do you understand the consequences of limiting the recalculation of formulas.
I suggest you review what you are trying to achieve and decide if you can get the required result without a circular reference.