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
Bookmarks