Posted to microsoft.public.excel.programming

iltheas

external usenet poster

Posts: 3

Replacing subtotal with a formula

Hi all,

ref: http://www.geocities.com/tompel79/aging_test_before.xls
http://www.geocities.com/tompel79/aging_test_after.xls

I'm new at this. I would like to calculate the subtotal of an aging
report, generated from AccPac. Currently, the system will generate the
subtotal, but I would like to replace all the subtotal with a formula
(Refer to aging_test_before.xls). Is there any easy way to do this?
Thank you very much.

Ferri.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
pasting to subtotal lines without replacing hidden -non-subtotal l	harleydiva67	Excel Discussion (Misc queries)	1	October 12th 06 06:02 PM
Replacing formula	James[_26_]	Excel Programming	2	August 11th 04 03:10 AM
Replacing Formula	James[_26_]	Excel Programming	2	August 9th 04 09:30 PM
replacing value by formula	monika	Excel Programming	4	March 4th 04 01:50 PM
Replacing a value from a formula	Squid[_2_]	Excel Programming	1	February 14th 04 02:02 PM

All times are GMT +1. The time now is 03:07 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us