+ Reply to Thread
Results 1 to 5 of 5

Move row from sheet to archive in a macro

  1. #1
    Forum Contributor
    Join Date
    05-18-2012
    Location
    Chicopee, Ma
    MS-Off Ver
    Excel 2010
    Posts
    194

    Move row from sheet to archive in a macro

    Please see the attached spreadsheet.
    I have a Macro that will move a highlighted row from one of the Dept sheets to the archive page.
    I works but it erases the last row in the archive file.
    I want to be able to add row underneath the previous archive entry, without deleting anything in the archive.

    Thanks in advance for any help.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Move row from sheet to archive in a macro

    Hi,

    There is nothing particularly wrong with your macro... as long as you have a value in column A.
    If you put a dummy value in cell A2 in the archive sheet and then try to archive another line it will work!

    Let me know how you go.
    Stephen

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Move row from sheet to archive in a macro

    Maybe:

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    05-18-2012
    Location
    Chicopee, Ma
    MS-Off Ver
    Excel 2010
    Posts
    194

    Re: Move row from sheet to archive in a macro

    Thanks , you were right.

  5. #5
    Forum Contributor
    Join Date
    05-18-2012
    Location
    Chicopee, Ma
    MS-Off Ver
    Excel 2010
    Posts
    194

    Re: Move row from sheet to archive in a macro

    thanks I'll give it a try.

+ 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. Move Entire Rows to Archive Worksheet
    By LBinGA in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-02-2016, 08:05 PM
  2. Move a Row to archive sheet - Values Only
    By lyla22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2015, 07:16 PM
  3. Macro to copy a line to archive sheet and delete from active sheet
    By mmccra2858 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-08-2015, 09:15 PM
  4. 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
  5. Replies: 1
    Last Post: 11-14-2014, 08:35 PM
  6. [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
  7. 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