I have a worksheet with an inherent circular calculation. To get the answers
to converge, I need to copy D85:W85 to row 55 as Values and hit shift+F9. I
keep doing this (about 5-6 times) till the numbers in row 55 and 85 are less
than 100 off.

Is there a way to automate this process with either a function or a macro?

Thanks in advance,

Anand