Posted to microsoft.public.excel.misc
|
|
An Issue with sub-total
You're very welcome...I'm glad that worked for you.
***********
Regards,
Ron
XL2002, WinXP-Pro
"arcticale" wrote:
THANKS RON!!!!!!!!!!!!!!!!!!!!
"Ron Coderre" wrote:
Try this:
Using the Pivot Table.....
Left-Click and hold on the column heading for the amounts.
Drag it to the right until it covers the "Total" column heading.
Release.
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"arcticale" wrote:
I have two columns with values in my worksheet. is there a way I can put this
side by side when I do the pivot table. Usually, it is one over the other.
thanks a lot
"Peo Sjoblom" wrote:
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
|