+ Reply to Thread
Results 1 to 3 of 3

VB Code to move rows if value in column B is zero

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VB Code to move rows if value in column B is zero

    Hello:

    Please refer to attached file.
    I have attached closed workbook @ C:\Temp\
    I need VB code to perform following to the closed workbook.
    Need to check "0" in column B and move that whole row at the end (to the last row).
    If it is already at the end then by-pass.
    In this file, i see 2 rows (row#129 and #130) with Zero in column B.
    So need to move these 2 rows to the end and move up the others.

    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: VB Code to move rows if value in column B is zero

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to move rows if value in column B is zero

    Hello AlphaFrog:

    Thanks a lot...Works great

    Riz

+ 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] For Loop to move Rows(B:D) Data to Single Column Consecutively. Code not working.
    By unit285 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2017, 03:07 PM
  2. Remove duplicate rows and move the column data to a new column
    By cmray58 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-22-2015, 03:46 PM
  3. Code to move VBred rows to next empty row
    By justlearning123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2015, 07:24 PM
  4. [SOLVED] Move the result to next column B available row if column A rows is not empty
    By Malou in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-29-2015, 11:02 AM
  5. Take rows of text and move to into a new column, each column easily identified
    By CATTX01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2015, 03:35 PM
  6. HELP: Move values from column to rows based on Column A
    By ExceJunkie in forum Excel General
    Replies: 2
    Last Post: 05-30-2013, 08:09 AM
  7. Code not working - move rows when cell is less than zero
    By wishmaker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-01-2011, 10:40 AM

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