Hello ahsanzafar,
The attached workbook will create a report from the "Data" sheet. There is a button on the "Report" sheet to run the macro. The button will not be printed when the sheet is printed.
This took some time because the report is dynamic. The needed rows are added based on IMEI and Party entries. The total row is added at the end of the table. There are no formulas in this report. The macro handles everything.
My assumption is you get one customer's data at a time and run the macro for each customer. if your needs are different, let me know and I will adjust the macro.
Although the code is rather long, it is fast. You will have the report as soon as you click the button.
Create Report Macro
Macro to Sort a List in Place
Bookmarks