Code To Update/Refresh Spreadsheet
Posted on 2013-01-14
I have no idea if this is even possible. I am hoping there is a code that I could put into my spreadsheet, that (assuming macro's are enabled) this " code " looks at range E:I, and after any cell has been entered with a value, then the spreadsheet automatically refreshes itself.
The reason, is because I have a cell in my spreadsheet that references "=NOW()" - and I need that cell to refresh with the current value. Cause there are certain cells dependant on that when values are entered into range E:I.
I hope that made sense.
Thank you in advance for your help!