Creating Macro to capture history

**claudiomonteverdi** · 03-30-2012, 02:01 AM

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.

**Mallycat** · 03-30-2012, 02:17 AM

most versions of excel have a "track changes" option. First you have to share the workbook (in 2010, go to REVIEW\SHARE). Then there should be an option to list changes in a new sheet.

**claudiomonteverdi** · 03-30-2012, 02:26 AM

Thanks Mallycat

Firstly, I want just a restricted range of thirty or so cells to be compared and tracked in a spread sheet of about thirty sheets. Secondly, I want any dummy to be able to see the changes without having to work too hard. I am a dummy myself, so I should know that this wouldn't work (Can I dummy assert that this won't work? did I just create a paradox? I dunno, coz dummies like me don't know words that big).

Anyway - Can the macro thingy be created, or is it just wishful thinking?