Results 1 to 5 of 5

Using a Macro to create a retention sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-07-2009
    Location
    Spain
    MS-Off Ver
    Excel 2003
    Posts
    128

    Using a Macro to create a retention sheet

    E.g in this workbook I have two sheets, Source and Retention Sheet

    My problem is that the source is constantly updated and I need to maintain a historical record of what the value of these cells were, almost like track changes.

    So the macro should
    1) When executed Copy =Source!A1:U8 and paste values into the retention sheet that would time, date and name stamp the person that run the macro.
    2) I would like it so the macro could be run multiple times and retain the data on the next available row.
    3) A prompt box that would allow the user to replace the previous entry if required.

    I could easily create a new sheet and paste values into there using a macro, however, that could just build too many sheets.
    Attached Files Attached Files

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