Macro to SUMIFS based on certain criteria and CONCATENATE Transaction nos.

Dear Friends,

I have a data in which date, transaction nos, type, amount collected etc are there. The no. of data may vary based on daywise collections.

Therefore, for summary, I need to SUMIFS the data (which is possible using Pivot but not in the required format) and CONCATENATE the transaction nos. as per the grouped data.

I attached the Excel file in which I furnished the detailed data and the SAMPLE OUTPUT requirement also.

Please help me to resolve.

Maybe :

Please Login or Register  to view this content.

Dear Sir,

Thanks for your kind & swift support. You are Great Sir.

You are welcome, thanks for marking the thread as solved and rep.points.

Regards

Dear Sir,
The above code is simply superb.

I need one more help in the above to apply in another file.

Almost the process is same, but the no. of SUMMING columns are less. And NO NEED TO CONCATENATE any column also.

I attached the sample file for your kind help. Please Sir.

Should be :

Please Login or Register  to view this content.

Oh ! You Beauty....
Great Sir. Take a Bow......
Thanks a lot Sir.

You are welcome.

Don't forget to mark this thread as solved :
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Dear Sir,
It worked very fine. I attached the Excel file in which I applied your code.

1) Your code works nicely in the table (sheet "Data1").

2) When I applied your code in sheet "Data2", then it returns with "Error #9 - Subscript out of range". What may be the issue? I tried my level best, but couldn't.

I attached the Excel File with both sheets & codes ("coderight" for sheet "data1" & "codewrong" for sheet "data2"), to run instantly to find error message.

Please help me to resolve it Sir.

Please change this line :

Please Login or Register  to view this content.

into this :

Please Login or Register  to view this content.