Results 1 to 10 of 10

Auto Sort values drawn from a VLookup table into ascending order?

Threaded View

  1. #1
    Registered User
    Join Date
    01-09-2012
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Excel 2007
    Posts
    54

    Auto Sort values drawn from a VLookup table into ascending order?

    Hey everyone!

    I am having trouble trying to figure this out. Basically, what I would like to do is have data in my worksheets that is drawn via the vlookup function auto sort in ascending order so that I am able to create a graph that will work. My actual project is quite big so I've attached a much smaller example. in my example, I have the master sheet, labeled VLookupTable, and another sheet where the sorting will take place. I would like the 'x values' of the graph (column B) to auto sort in ascending order while keeping the other values in the columns next to them actually stay next to them. My actual project is way to big for me to manually do this in like 100 sheets.

    I've tried to do this multiple ways by searching the internet, but Im not sure if the fact that the values are drawn from a Vlookup table is interfering with the capability to auto sort. Any help would be great!

    -Dan
    Attached Files Attached Files

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