Hi all apologies, this is my first post so bear with me!
I'm running a macro in Excel which monitors values in a range of cells (say for arguments sake B2:C13) and if it sees any change in the cell, it will run another sub to copy the former values into a column (imagine it is for tracking stock...