Closed Thread
Results 1 to 2 of 2

Performing an intelligent sort based on cell value

  1. #1
    Registered User
    Join Date
    04-03-2012
    Location
    Denver, Colorado
    MS-Off Ver
    Excel 2007
    Posts
    7

    Performing an intelligent sort based on cell value

    Hi, I'm looking to make a formula that will intelligently sort through selected cells in rows and put the lowest valued cell on a different sheet of the workbook, while also depositing the contents of the cell to the immediate right of it to the right of cell in the new sheet as well. The one last thing I'm hoping it can do is put the header of the column in either the cell to either side of the newly created cells in the new sheet, or convert it into a note. My hope is that this formula will automatically go through my pricing worksheet and sort what vendor had the lowest price, with their lead time next to it, all on a seperate, easier to reference sheet because the spreadsheet as it is now is a huge spralling affair. Any thoughts or ideas?

    Thanks!
    Mouse

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Performing an intelligent sort based on cell value

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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