+ Reply to Thread
Results 1 to 4 of 4

Move a Row to archive sheet - Values Only

  1. #1
    Forum Contributor
    Join Date
    05-24-2012
    Location
    Cork, Ireland
    MS-Off Ver
    Excel 365
    Posts
    149

    Move a Row to archive sheet - Values Only

    Hi ,


    In the attached file, a macro moves the row from the Current Data worksheet to the Archive sheet when the status is changed from Current to Complete.
    I would only like to paste the values & formatting for these rows, not any formulae.

    Any ideas on how I can tweak the code?

    Thanks in advance...
    Attached Files Attached Files

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Move a Row to archive sheet - Values Only

    Maybe this little change to your worksheet change event code.

    Please Login or Register  to view this content.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Forum Contributor
    Join Date
    05-24-2012
    Location
    Cork, Ireland
    MS-Off Ver
    Excel 365
    Posts
    149

    Re: Move a Row to archive sheet - Values Only

    Thank you!

    Works perfectly.

  4. #4
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Move a Row to archive sheet - Values Only

    Quote Originally Posted by lyla22 View Post
    Thank you!

    Works perfectly.
    Thank you for the rep. points and feedback.

    If your original request is fulfilled please click the Thread Tools drop down box above your first post and choose solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trying to Move an entire Row from one sheet to another Archive sheet.. Also..
    By Gurbo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-15-2014, 10:50 AM
  2. Replies: 1
    Last Post: 11-14-2014, 08:35 PM
  3. [SOLVED] Need a macro to copy dates & data from one sheet to an updating archive sheet
    By pbj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2013, 06:58 PM
  4. Move data from multiple tables onto a list to archive and analyse
    By sallyfield in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2012, 11:52 PM
  5. Move a Record to Archive
    By dreicer_Jarr in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-14-2011, 10:22 PM

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