Gary L Brown Wrote:
> Create a 'Helper' column with a formula such as...
> =A2 & H2
> Then use this column for the 'At each change in:' of DataSubtotals to
> create a subtotal in Col C.
> HTH,
> --
> Gary Brown
> gary_brown@ge_NOSPAM.com
> If this post was helpful, please click the ''''Yes'''' button next to
> ''''Was this Post Helpfull to you?".
>
>
> "john liem" wrote:
> -
>
> How can I have subtotals of Col. "C" (sum of price) at each change in
> Col. "A" (product) or Col. "H" (country) on 1 line? I want to have
> the
> subtotals below the data line. Has somebody a VBA script for it? I am
> using Excel 2003, thanks.
>
>
> --
> john liem
> -
A very good suggestion and solution, thanks Gary !!!


--
john liem