Sounds as you could use a pivot table instead

http://peltiertech.com/Excel/Pivots/pivottables.htm

http://www.contextures.com/xlPivot02.html

--
Regards,

Peo Sjoblom

(No private emails please)


"arcticale" wrote in message
...
What is the best way to do this :
I have several columns in my spreadsheet, I sub-totaled every change in
Sta
tement. When i compress the file, of course, the only visible rows are the
sub totals which says:
statement1 total xxx
statement2 total xxx
statement3 total xxx

is there a way for me to see the column contents so that my spreadsheet
will
look like this :

Account Statment Amount
1000 Statement1 total xxxx
2000 Statement2 total xxxx
3000 Statement3total xxxx

I tried data fill. But wont work

thanks and have a great new year everyone

del