I want to be able to track changes in a particular range of cells.
One way I have though of doing this would be to create a Macro that would copy the required information and paste it into a separate sheet (let's call it the "History Sheet") in a non-editable manner. The process is to be triggered with the press of a button. Each time this is done, it will paste the required information directly below the data pasted the last time the button was pressed. I want the date and time the data was pasted to also be recorded with the data itself in the History Sheet.
It should resemble roughly somthing like this:
"History Sheet"
History Data - 30 March 2012 4:30 PM
Blah A... Blah B.. Blah C..
History Data - 2 April 2012 10.00 AM
Blah A.. Blah D.. Blah C..
History Data - 14 April 2012 1.00 PM
Blah A.. Blah D.. Hogwash F..
I don't know how to use VB yet and have only created one or two macros.
Any help you power users can offer me would be greatly appreciated.
Bookmarks