Advanced filters using VBA
I have a job to generate reports of user based worksheets (phone bill details) to calculate total incoming/outgoing calls and sms from a specific user. I do it by using filters.. (See the attachment file "data" is the phone bill and "report" is the analyzed sheet..
I want to make a macro to do the job for me..
Put this formula in cell B10 and then you can copy it down and across.
Formula:
Please Login or Register to view this content.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Your code works fine.. but i have to manually add each number in Report sheet.. kindly write a code to automatically generate Report Sheet and add each Number..
It should also calculate total rows in data sheet etc.. coz there are thousands of sheets for me to Analyze.. Please Help me saving my butt
Last edited by ahsanzafar; 11-08-2015 at 02:33 PM.
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
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Leith Ross; 11-09-2015 at 07:39 PM.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hello ahsanzafar,
Thanks for the rep points. Does the macro do what you want?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks