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