+ Reply to Thread
Results 1 to 2 of 2

Cut Row to New Sheet, Delete From Previous - based on value in two different columns

  1. #1
    Registered User
    Join Date
    04-13-2017
    Location
    Scottsdale, AZ
    MS-Off Ver
    Microsoft 2010
    Posts
    1

    Cut Row to New Sheet, Delete From Previous - based on value in two different columns

    Hi All!

    Goal:
    Entire row on Outstanding Issuance & Invoice sheet to be cut and pasted to either the Missing Primary Policies tab or the Completed Accounts tab. Once the entire row is cut and pasted, the original blank row should be deleted.

    This should only happen if the cell in column S for the active row contains a date. I have been trying to use Not IsBlank but got nowhere. Various dates will be entered. If the cell in column S for the active row is blank, nothing should be done.

    If the above criteria is met and the cell contains a date, then the status in Column G determines which tab the row is pasted to. If the cell in Column G = Missing Primary Policy(ies) the row is pasted in the next blank row of the Primary Policies Outstanding tab. If the cell in Column G = Account Complete - All Info Received the row is pasted in the next blank row of the Completes Accounts tab.

    This should happen starting with row 3 until a blank row occurs.

    Current Code:
    The below code is what I am working with now. It partially works, but it does not loop through properly. Anything with Account Complete - All Info Received seems to all be moving, however not all the rows with column G cell value as Missing Primary Policy(ies) seem to be moving. I also need to add the criteria so this only happens is the cell for the active row in Column S is not blank.

    Please Login or Register  to view this content.
    Last edited by alansidman; 04-14-2017 at 12:40 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Cut Row to New Sheet, Delete From Previous - based on value in two different columns

    Code Tags Added
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. [SOLVED] Delete Sheet Rows & Columns based on cell value
    By brendangroff in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-10-2016, 05:22 PM
  2. Delete Columns( From One Sheet) based on the header name from a list.
    By v_a_royston in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-29-2015, 08:07 PM
  3. Autofilter, copy from sheet 1 and paste to sheet2, delete previous info on sheet 2
    By leigh12483 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2015, 08:21 PM
  4. VBA Code to delete the previous sum addition saved in summary sheet
    By kumesh10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2013, 11:54 PM
  5. Replies: 3
    Last Post: 11-06-2012, 11:26 AM
  6. Creating a macro that will delete row based on non matching cell to previous line
    By freidhofr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-22-2012, 03:47 PM
  7. Macro to add sheet, name it based on previous sheet, and delete a range of cells
    By Moeshell in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-24-2011, 03:26 PM

Tags for this Thread

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