Results 1 to 3 of 3

Creating Macro to capture history

Threaded View

  1. #1
    Registered User
    Join Date
    03-30-2012
    Location
    Australia, The World, The Solar System, The Milky Way, The Universe
    MS-Off Ver
    Excel 2010
    Posts
    4

    Wink Creating Macro to capture history

    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.
    Last edited by claudiomonteverdi; 03-30-2012 at 02:26 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1