+ Reply to Thread
Results 1 to 5 of 5

If/Then to move rows into different sections of the same sheet

  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    Jersey City, NJ
    MS-Off Ver
    Excel 2003
    Posts
    3

    If/Then to move rows into different sections of the same sheet

    I am hoping I can get this done without a macro as I have not written code in years but I'm pretty sure it will not be possible. Anyway, I have a spreadsheet that tracks sales opportunities based on odds. If it is high odds it belongs in the top section, decent odds the middle section, and low odds, the bottom section (these are the only three). These entries are pulled from a master sheet that is essentially a pull from a large DB and does very little organization on its own. This master sheet changes daily so I am constantly pulling new data in and old data is constantly falling out.

    I would like to create a column that includes a 1, 2, or 3 on my sheet and when this number is changed, the entire row and associated formulas automatically move to the correct section. What would be especially helpful is if I could get it to move to the correct section and in a row that places it into descending order based on the revenue column.

    I hope I explained this clearly and would greatly appreciate any assistance or advice. If I can get this done without a macro, I am all ears as I am a little fearful about something changing and being unable to fix it. Thanks in advance for your help.

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: If/Then to move rows into different sections of the same sheet

    attach please a sample file with current and desired table
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    09-20-2012
    Location
    Jersey City, NJ
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: If/Then to move rows into different sections of the same sheet

    Quote Originally Posted by patel45 View Post
    attach please a sample file with current and desired table
    Excel Forum.xls

    Let me know if this works.

  4. #4
    Registered User
    Join Date
    09-20-2012
    Location
    Jersey City, NJ
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: If/Then to move rows into different sections of the same sheet

    Any update? Can someone else possibly help me with this request?

  5. #5
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: If/Then to move rows into different sections of the same sheet

    it's not clear for me what you want

+ 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