Want to Auto Report of attached file using Macro VBA

[Mohsin Kodvavi]

Mile Stone For Statement.xlsxAttachment 410758
Please help me Pro Excel Users
have a Data is in 2 sheets Sheet1 is Reciept Sheet2 is Due I want to creat a Macro for Aging Report from both 2 sheets In this sheet3 is displaying dues and what i want is in Aging Report Sheet an i insert a macro button

[ranman256]

What does this mean?
Print a report?

[Mohsin Kodvavi]

not for print automatically just display the result auto if i want i print it manually ..

[Mohsin Kodvavi]

Mile Stone For Statement.xlsxRanman i attached file again .... what i want is in Aging Report Sheet an i insert a macro button please see the file again Ranman235

[Mohsin Kodvavi]

not for print automatically just display the result auto if i want i print it manually ..

Help me Plzzz

[Mohsin Kodvavi]

I have a Data is in 2 sheets Sheet1 is Reciept Sheet2 is Due I want to creat a Macro for Aging Report from both 2 sheets In this sheet3 is displaying dues and

[jaslake]

Mohsin Kodvavi

Try the Code in the attached.

Button Code:

Please Login or Register  to view this content.

Globals:

Please Login or Register  to view this content.

Prep Data Code:

Please Login or Register  to view this content.

Create Aging Report Code:

Please Login or Register  to view this content.

[Mohsin Kodvavi]

THANKS jaslake MY ISSUE IS ROSEOLVED BY YOU IT'S WORKING PROPERLY NOW I HAVE SO MUCH TO RELAX IN MY OFFICE THANKS TO YOU

[Mohsin Kodvavi]

Where is the option of event code? I have to marked as solved

[Mohsin Kodvavi]

Is it possible that in the result sheet it shown the detail less than today because i dont to show the statement for all dues i just want to show the result uptill now

[jaslake]

You're welcome...glad I could help...thanks for the Rep.

To mark your Thread as SOLVED:

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[jaslake]

Hi Mohsin Kodvavi

Are you saying Filter out all Dates greater than today's Date?

Assuming "Yes", rather than rewriting the Code to accommodate that I've added two lines of Code to "Sub Create_Aging_Report()" that filters Sheet Aging Report to show only those Dates that are less than or equal to Todays Date.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Replace "Sub Create_Aging_Report()" with this Code...

Please Login or Register  to view this content.

[Mohsin Kodvavi]

Thanks for Every thing :D :p

[Mohsin Kodvavi]

It is working fine my data ... But it's not working when i open new account in dues and reciept it give me an error for debug or end
can u resolve the new issue for me .... It's not working when i opened an new account code
????

[Mohsin Kodvavi]

Not working when i opened an new account

[jaslake]

Hi Mohsin Kodvavi

Please attach the File that exhibits the issue.