Sorting

[TimB via OfficeKB.com]

i have a worksheet that has tables (for lack of a better word) that are ten
rows long. it has about 100 of these tables. the heading for each table is
in the upper most left art of each table. is there a way that i can sort by
using that cell? something that will give me the rows beneath it when it is
selected. i have a sample copy of the worksheet but dont know how to post it.
it would clear up what i am askin if anyone is interested in helping. thanks

 

[Max]

Some thoughts ..

Assuming the top left table header cells are in A1, A11, A21, ..., place in
an adjacent col just to the right of the tables, eg in E1 (assuming the
tables are in cols A to D):
=OFFSET(INDIRECT("A"&INT((ROW(A1)-1)/10)*10+1),,)
Copy E1 down as far as required. Then select cols A to E, sort by col E >
ascending/descending.