Sorting
 

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200703/1

Sorting
 

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"TimB via OfficeKB.com" <u32108@uwe wrote in message
news:6f606c6154a6b@uwe...
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200703/1