Hi there,
I would like to know how to create a macro which takes a snapshot of a data range and copies it into a new workbook before the information is changed (without just simply copying and pasting). For example if I have a cell with value "John" I would like to be able to run a macro which puts this information into a new worksheet before I change "John" to "Matthew". Could you please advise if this is possible and how I can do this?
Thanks very much, Helen