Table

C

CraigM

Hi,

I have a table which will be changed on a weekly basis.

I have in the 1st column numbers 1 to 17. these i want to stay put. in
column 2 i have peoples names and in columns 3 and 4 i have last weeks
outstanding and year to date outstanding.

In column 3 each week will change and obviously this means column 4 will
change also.

What i would like is for when someone has the highest outstanding amount in
the year to date column to be moved to the top. Like in a league table.

If you need any more information on my task please ask.

Regards

Craig
 
D

Dave Peterson

It sounds like you could select your range in columns B:D and do Data|Sort and
sort by column D.

If you don't include column A in your selection (and you choose not to expand
your range--if prompted), then excel will just sort the columns you have
selected.
 
C

CraigM

Hi Dave,

Thanks for the response. Would this automatically update every week or would
i have to sort every week.

Regards

Craig
 
D

Dave Peterson

Sorting is a manual effort. You'd have to do it whenever you wanted the data
sorted.

Someday when you're feeling more industrious, you could record a macro when you
do it manually. Then you could just replay that macro whenever you needed the
data sorted.
 
Top