Sum and merge based on change in value

[cbk40060]

Recently I saw the reply given by rylo on 09-09-2010, to XL2008 regarding the Thread: Macro - Sum and merge based on change in value.
The code provided by rylo is as under:

Please Login or Register  to view this content.

I am using a Pentium 4 PC with a 2.40 G.Hz processor and 3 GB RAM. Further, I am using Windows XP SP3 and Office 2007.
I tried the above referred macro codes given by rylo , in a excel 2007 file having about 14000 records.
The macro hangs there and does not complete its job, even after about 2 hours.
The excel.exe uses more than 95% CPU Usage & more than 24356K memory-usage.
Will you provide me a better macro which works quickly.
Please help.
Thanks.

[JBeaucaire]

Functions that are fraught with "recalc" woes are a COUNTIF, Merge Cells, and a row by row LOOP that might need to repeats 10s of thousands of times.

I would suggest data like this be left alone and referenced as a SOURCE for a report you create separately. SUMIF() formulas can collect all the values for a single matching "category". SUMIFS() can collect all the values from one column for multiple tests in other columns.

A Pivot Table may be the best solution of all.

[cbk40060]

I have attached the sample excel file. But please note that the original excel file has more than 14000 records. I want the macro to sum the values in column C(AMT), for each change in value in the column A (CLIENT_CODE) and populate the column E (TOT_AMT) with the calculated sums.
Please help me.
Thanks.
=====================
Hello everybody. I have attached the revised sample excel file, which is shorter & more explanatory.
The revised sample excel file contains both the existing data & required output.
But please note that the original excel file has more than 14000 records.
Please give me a good macro to achieve this task.
Thanks