Sun, 16 May 2010 04:39:01 -0700 from [rajath] <[rajath]
@discussions.microsoft.com:

I have a question about sorting/custom sort.

In a worksheet, I have 8 individual tables. Each table has 8 columns and 4
rows. I need to sort each of the table according to the decreasing values of
3 columns. I have no problem with this.

I used the function 'custom sort'. I find that when I apply this to the
second table, the 'custom sort' of the first table vanishes. Altogether, I am
able to get the 'custom sort' into only 1 table. But I need the sorting in
all the 8 and I cant combine them into a single table.

Please help. Thanks in advance.

AFAIK, only the most recent custom sort settings are stored, so when
you want to sort a different table you have to enter the settings
again.

I think the thing to do is to create a macro. The macro would sense
which is the current cell, and the would sort the table that contains
that cell.

To create the macro, you can Record while doing a sort, then use that
as a guide to create the other seven sorts. All you have to do then
is add the logic to pick which sort, based on current cell. Or, if
the tables aren't too large, you could perhaps just sort all eight
tables without regard to the current cell.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...