Usually when looking for ways to program Excel commands in Visual FoxPro, it helps to give the commands interactively in Excel first, while you save a macro. Then look at the resulting commands.
>Hi,
>I have a worksheet, have three columns and
> A B C
>1 Client Code Item No. Qty.
>2 AAA 1111 3
>3 AAA 1111 1
>4 AAA 2222 2
>5 BBB 1111 2
>6 BBB 1111 1
>7 BBB 2222 3
>8 BBB 2222 5
>
>How to set grouping to the worksheet as following result ?
>
> A B C
>1 Client Code Item No. Qty.
>2 AAA 1111 3
>3 AAA 1111 1
>4 tot: 4
>5 AAA 2222 2
>6 tot: 2
>7 BBB 1111 2
>8 BBB 1111 1
>9 tot: 3
>10 BBB 2222 3
>11 BBB 2222 5
>12 tot: 8
>
>How to coding ?
>Please advise.
>
>Thanks.
>Derek
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)