Results 1 to 5 of 5

Move row from sheet to archive in a macro

Threaded View

  1. 01-21-2016, 08:05 PM #1
    mmccra2858
    mmccra2858 is offline
    Forum Contributor
    Join Date
    05-18-2012
    Location
    Chicopee, Ma
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    199

    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
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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. Trying to Move an entire Row from one sheet to another Archive sheet.. Also..
    By Gurbo in forum Excel Formulas & Functions
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1