Hi can anyone help with this,
I have this data where i need to sum;
abcd 216.00
abcd 572.00
eeee 649.00
zzz 396.00
eeee 564.00
eeee 1,194.00
fffff 731.00
fffff 54.24
zzz 731.00
zzz 885.00
abcd 598.24
zzz 241.24
eeee 153.00
zzz 403.00
I need macro to sum allthe same group into
eeee (total here)
zzz
fffff
the reason i need this is to enable me to do this to thousands of data and used copy and paste to produce a reports.
I have this data where i need to sum;
abcd 216.00
abcd 572.00
eeee 649.00
zzz 396.00
eeee 564.00
eeee 1,194.00
fffff 731.00
fffff 54.24
zzz 731.00
zzz 885.00
abcd 598.24
zzz 241.24
eeee 153.00
zzz 403.00
I need macro to sum allthe same group into
eeee (total here)
zzz
fffff
the reason i need this is to enable me to do this to thousands of data and used copy and paste to produce a reports.