Dynamic Sort

**ComradeBT** · 07-05-2010, 10:22 AM

I have a ranking table of figures, sorted in order from high to low. These figures are referenced from a selection of cells elsewhere in my worksheet.

Is it possible for my ranking table to dynamically (automatically) update itself if I change the source cells of figures? Or do I always have to re-apply the sort on my table manually?

**martindwilson** · 07-05-2010, 11:37 AM

yes it probably is! but post what you have

**ComradeBT** · 07-06-2010, 06:39 AM

Hi Martin,

Sample attached.

The information on the 'Rankings' worksheet is a snapshot of data, itself sourced from a variety of cells I have elsewhere. I then use this 'Rankings' worksheet to populate a 'Dynamic Sorting' worksheet I have. Within the table here, is it possible to automatically sort that so the data is presented in order of the 'Amount' from high to low?

I wish for this to be automatically done rather than having to constantly re-apply the sort manually because the source data on the 'Rankings' worksheet is dynamic and ever-changing.

Hope you can help?

Ben.