1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. 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


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

Create Dynamic Dashboard

Discussion in 'VBA Macros' started by Vijayarc, Jan 11, 2017.

  1. Vijayarc

    Vijayarc New Member


    I want dynamic interactive dashboard in excel with data in will on daily basis

    I want dashboard to geneate report on weekly/ monthly , Product wise, Username Release wise, Usernamer Maker

    Attached Files:

  2. vletm

    vletm Well-Known Member

    I would like to know ...
    Why did You open case under VBA Macros, if You want a dashboard?
    There are two days data ... it's nice to test weekly/monthly-report?
    Why did You want to use other terms than in sample file?
    Do You have clear vision of Your wanted dashboard?
    If so, then You would add it to sample file too.
  3. Awesome Wally

    Awesome Wally Member

    Does a simple Pivot table/chart with some slicers suffice? Without a better idea of what you are looking for in terms of a dashboard, I think a pivot table and Date slicer will work for you.
  4. Vijayarc

    Vijayarc New Member

    Hi sir,
    Please find my requirement, hope my requirement is clear and waiting for reply

    I Have excel , in that we update reports on daily basis by adding new sheet
    1. i want to combine all sheets in one consolidate master sheet
    2, with that consolidated sheet, we want 2 pivot tabel based on criteria
    3. so i want below button click function
    1. button to Combine all sheet to one master sheet
    2. button to Pivot Table1
    3. button to Pivot Table2
    4. i want Dynamic linked slicers to filter data

    Attached Files:

Share This Page