Hi all,

I'm trying to look for a solution for the following: Without using pivot table.

Before :
DC664AV 5
DC664AV 6
DC970AV 4
DK560AV 34



After macro applied:
DC664AV 11
DC970AV 4
DK560AV 34

Greatly appeariate if u can help.
Thanks!

Shirley T

Data= Subtotals, group on your first column and sum on the second. Use the
outline feature to collapse the rows so only the totals are shown.

--
Regards,
Tom Ogilvy

"Shirley T" wrote in message
om...
Hi all,

I'm trying to look for a solution for the following: Without using pivot
table.

Before :
DC664AV 5
DC664AV 6
DC970AV 4
DK560AV 34



After macro applied:
DC664AV 11
DC970AV 4
DK560AV 34

Greatly appeariate if u can help.
Thanks!

Shirley T

Hi Ogilvy,
thanks for the answer, however, Data= Subtotals wasn't the desire
method that i prefer. I'm the begining learning for VBA, And I really
want to see if writing a macro script to bring up my answer.

The Data= Subtotals way is good, but i still have to manual remove
the word "total" and, manual copy the result to another sheet.

may u help?
Show me a way if u can! Millions thanks!

ST




"Tom Ogilvy" wrote in message ...
Data= Subtotals, group on your first column and sum on the second. Use the
outline feature to collapse the rows so only the totals are shown.

--
Regards,
Tom Ogilvy

"Shirley T" wrote in message
om...
Hi all,

I'm trying to look for a solution for the following: Without using pivot
table.

Before :
DC664AV 5
DC664AV 6
DC970AV 4
DK560AV 34



After macro applied:
DC664AV 11
DC970AV 4
DK560AV 34

Greatly appeariate if u can help.
Thanks!

Shirley T