OK, so you're trying to calculate both columns. And, since each references the other, you're getting the circular references.

Might I suggest that a better approach could be to have separate input & output columns? That way you'll have a lasting record of which figures you actually input for each provider. If you simply use a macro to update whichever column you don't input data into, you'll lose that visual record.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]