ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   copy-paste as Values automatically (https://www.excelbanter.com/excel-worksheet-functions/46960-copy-paste-values-automatically.html)

Anand

copy-paste as Values automatically
 
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 D86:W86 are less than
say 100.

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

Thanks in advance,

Anand


All times are GMT +1. The time now is 06:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com