Hi,

I have a two column table of names and related values e.g. Fund1 6%, Fund2
11% etc. The table references another table so the cells have references not
actual values. When i try to set up a list and sort by top 10 it doesn't
work. when i copy and paste values then it will sort. But i would like to
automate the process - so when the parent table changes then the new top ten
values are automatically calculated...can anyone help? (excel 2003)

Thanks!!!