I wish to add a loop macro to a spreadsheet I'm working on, but have next to no experience. This is what i'd like to do:
Cell L11 is determined by another cell + cell K11. As cell L11 is directly related to cell K12, i need to iterate it a certain amount of steps or the spreadsheet breaks...
I have set up another cell (K12) so that it is empty if K11 is within +- 10 from L11, so I want a code that will stop the iteration process when that cell is empty.
An alternative way of doing it might be to say I only want it to iterate 5 times, and then use that number - I only really need a vague accuracy. (number will vary from 10-1000)
Can anyone help me? Thanks!