Auto Sort ??

  • Thread starter Thread starter wings91
  • Start date Start date
W

wings91

I have a worksheet named "Daytona" with range B2:e33. All data in the
range is taken from other sheets. Row heading are
B2-Name
C2-Driver
D2-Points
E2-Total
Data for column D is entered on sheet "Drivers". Data for column E is
a sum taken from sheet "Results"

I would like to sort the range B3:E33, decending, by column E, whenever
the data in column E changes

This is one sheet of 36 that have different names, but take data from
the same sheet that I would like to sort as well.

I've tried VBA codes from others in the forum, but those don't seem to
work, and thought it was because all the data is coming from another
sheet. The user never enters anything on the sheet that I want to
sort.

Thanks,
DAVE
 
I would like to sort the range B3:E33, decending, by column E, whenever
the data in column E changes
Click to expand...

You have to use some additional cells. I'll call them A103:E133.
in A103 put:
=RANK($E3,$E$3:$E$33)
in B103 put:
=INDEX(B$3:B$33,$A103)
fill right from B103 to E103
fill down from A103:E103 to A103:A133
 
Back
Top