+ Reply to Thread
Results 1 to 3 of 3

Reduce rows according to cell values

  1. #1
    Registered User
    Join Date
    04-15-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2007
    Posts
    36

    Unhappy Reduce rows according to cell values

    Hello All!

    I have a quite special problem here (Well at least for me ).

    So the basic idea would be, that you can select any cell, it will copy the current row on a new sheet. Then it would list all first other rows, which have a lower level value then i have selected. After this, it would copy all other levels, whicch have higher level value and are after the current row. So this would make a more visible hierarchy for me.

    So i started with this:

    ActiveSheet.Cells(activecell.Row, 1).Select
    currlvl = activecell.value

    So i have the current level in a variable.

    And then I got stuck. Here I should make the macro run backwards and search for the first cell in the same column, which has lower value then the currlvl. Copy that row to the other sheet, change currlvl to new and move on to the next level which is lower, copy again etc. The thing is, that i have no idea, what command i should use here. for or loop or something i dont even know?

    I have made a screen of original list and desired result, and I attached an excel file also with it.

    reduce.jpg
    reduceline.xlsx


    This would help me a loooooot, could you Masters help me?

    Thank you in advance,

    Ambrus

  2. #2
    Registered User
    Join Date
    04-15-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: Reduce rows according to cell values

    I pretty much started to look backward with the following:

    Sub back()

    Dim x, n, i As Integer

    x = activecell.Row

    For n = x To 1 Step -1
    Cells(n, 5).Select
    activecell.FormulaR1C1 = "yaaay"

    Next

    End Sub


    Seems i can list the if statements within this then.

  3. #3
    Registered User
    Join Date
    04-15-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2007
    Posts
    36

    Lightbulb Re: Reduce rows according to cell values

    Hi All,

    I might be not the prettiest problem solving formula, but this works for me just fine. Thought if someone would be interested in a similar problem, could use my source code. Here it goes:

    If you have nicer solutions, feel free to post it.


    Please Login or Register  to view this content.
    Regards,

    Ambrus

+ 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: 12-17-2013, 03:18 PM
  2. [SOLVED] Reduce the number of rows in a spreadsheet
    By Bcaster in forum Excel General
    Replies: 4
    Last Post: 10-29-2013, 10:56 AM
  3. Reduce sheet to rows with certain value
    By JayM in forum Excel General
    Replies: 5
    Last Post: 11-30-2009, 06:29 PM
  4. Reduce number of rows and columns
    By rajeshnair in forum Excel General
    Replies: 5
    Last Post: 12-07-2008, 03:30 PM
  5. [SOLVED] How do I reduce the no. of rows & columns in a worksheet ?
    By Anna Walton in forum Excel General
    Replies: 2
    Last Post: 05-30-2006, 12:25 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