+ Reply to Thread
Results 1 to 2 of 2

How Do I Automatically Move Entire Row to Another Worksheet?

  1. #1
    Registered User
    Join Date
    08-31-2012
    Location
    Amherst, MA
    MS-Off Ver
    Excel 2010
    Posts
    22

    How Do I Automatically Move Entire Row to Another Worksheet?

    What I am trying to accomplish is quite simple:

    I have two worksheets: "Packages" and "Archive". Both worksheets have information in columns A:K from the 8th row down.
    Whenever rows A:K in "Packages" worksheet (below the 8th) are all not blank (i.e. have text typed into them), I want the entire row to be cut, and pasted directly below the 7th row in the "Archive" worksheet (becoming the new 8th row of the "Archive" worksheet.

    I feel like this should be really easy to do, but I haven't been able to figure it out.
    any help will be appreciated!

  2. #2
    Registered User
    Join Date
    08-31-2012
    Location
    Amherst, MA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: How Do I Automatically Move Entire Row to Another Worksheet?

    I have been able to come up with this much:

    Please Login or Register  to view this content.
    but I still have to hard code the maximum row number that is accessed in the third line of code (right now it is set at the first 1000 rows). Is there any way to either make it run more efficiently, or count the number of cells that it needs to go down to?

+ Reply to Thread

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