+ Reply to Thread
Results 1 to 3 of 3

Move every other cell in a column to row above it, then delete the previous row-help

  1. #1
    Registered User
    Join Date
    07-05-2006
    Posts
    7

    Move every other cell in a column to row above it, then delete the previous row-help

    I have a spreadsheet that I need to rearrange to improve readability.
    I have an example attache, which is easier to understand than describing it, but I'll try:

    I want to start in a1, move to a2
    copy a2 to b1
    delete line 2 (the previous lrow 3 now becomes row 2
    if a2 > 0.01, skip it and
    move & select cell a3
    ... and repeat the above logic, on the next series of cells...
    eg
    copy a3 to b2
    delete line 3 (the previous lrow 4 now becomes row 3
    if a3 > 0.01, skip it and
    move & select cell a4
    ...and repeat the sequence again.

    The code that I wrote partially works - When I add in the commented out lines, it does not do what I described above.
    Could someone show me the error of my ways?
    Please Login or Register  to view this content.
    The code with the lines commented out, works to select, and move the cells in each row..when I uncomment the code that checks and skips a row, it does not behave the way I intended.

    Any help is appreciated.

    Best regards,
    J
    Attached Files Attached Files
    Last edited by jjh; 07-11-2014 at 01:53 AM.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Move every other cell in a column to row above it, then delete the previous row-help

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    07-05-2006
    Posts
    7

    Re: Move every other cell in a column to row above it, then delete the previous row-help

    Thank you very much!
    I noticed that when I convert the word doc to excel, some of the text lines span two rows, which causes the algorithm to hickup...I need to fix the converdsion.

    How would the macro need to be changed so that the output goes to a new sheet within the workbook?

    Thank you
    J

+ 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. Replies: 1
    Last Post: 04-29-2014, 08:28 PM
  2. [SOLVED] Fast way to move down a column until active cell is smaller than the previous cell value
    By herbie226 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-09-2014, 05:44 AM
  3. Auto-move previous content from cell a to cell b by changing cell a
    By Matt81a in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2013, 03:32 PM
  4. move back to previous cell if..
    By lucky_2say in forum Excel General
    Replies: 3
    Last Post: 04-28-2011, 09:40 PM
  5. Sort Column, Delete Rows, Delete Column, Move Molumn, more inside?
    By motown in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-13-2008, 09:44 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