• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Accounts Receivable Dashboard

J

joshuaacke

New Member
Hi,

I want to achieve the Dashboard. The costumer is filtered and when I select a costumer it will display all the overdue invoice of selected costumer.

Thank you in advance.
 

Attachments

  • AR Dashboard aging 30 60 90 days.xlsx
    15.4 KB · Views: 7
In the attached, change the drop down in cell C4, then refresh the table below it, either
by clicking Refresh All button in the Queries & Connections section of the Data tab of the ribbon
or
by right-clicking the table somewhere, and choosing Refresh.
If you don't do this, the table is set to refresh itself every minute anyway.
I've put the red border summary data to the right of the main table since the table length may vary.
 

Attachments

  • AR Dashboard aging 30 60 90 days.xlsx
    15.4 KB · Views: 6
p45cal said:
In the attached, change the drop down in cell C4, then refresh the table below it, either
by clicking Refresh All button in the Queries & Connections section of the Data tab of the ribbon
or
by right-clicking the table somewhere, and choosing Refresh.
If you don't do this, the table is set to refresh itself every minute anyway.
I've put the red border summary data to the right of the main table since the table length may vary.
Click to expand...
Thank you for the information. I will check it.
 
p45cal said:
In the attached, change the drop down in cell C4, then refresh the table below it, either
by clicking Refresh All button in the Queries & Connections section of the Data tab of the ribbon
or
by right-clicking the table somewhere, and choosing Refresh.
If you don't do this, the table is set to refresh itself every minute anyway.
I've put the red border summary data to the right of the main table since the table length may vary.
Click to expand...
There is nothing change in the attached excel file :)
It is the same excel file that I previously attached :)
 
You must log in or register to reply here.
Back
Top