Results 1 to 1 of 1

Auto sort

Threaded View

  1. #1
    Registered User
    Join Date
    07-26-2007
    Posts
    1
    I have a similar question but I really need a precise answer cause I'm not really introduced to Excel yet. I have joined the document I am working on, so please look at it while I explain my problem.

    Currently I have written down in col B and col D some numbers which are added together for each row and that gives out the total on col E. I have also sorted col E from the smallest number to the biggest, along with the rest of the row. (except for the first row which is the menu/title of the columns)
    What I mean by that is that say row #2 will always stick with the informations on that row, even if it moves down; not only E2 will move down if the number is bigger, but the whole row too.

    What I want now is to have the col E sorted everytime I change/add a value in a cell in the col B or col D, and for every row to follow like I explained earlier.


    Also, note that in the document I have prepared a longer table than needed right now. If possible, if I chose to add some informations on the next rows later, I would like that it would apply to those rows too. (up to row 26) Otherwise, if it can't work with blank cells, I would like if you could tell me how to change the values whenever I need to expand my table.

    I need to know how my entries would look like, cause if I have a number in a cell and you're telling me to write a formula in that same cell, I wouldn't know how to write both together.

    I hope I've been clear ._.
    I would like to learn how to do it so please don't just edit my file and attach it in your post.

    Thank you in advance for your help ^^
    Last edited by VBA Noob; 07-26-2007 at 01:07 PM.

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