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

Dynamic Dashboard Reqd

R

rush2rajen

Member
Hi Excel Gurus,

Please help in creating a DASHBOARD which will look like the one given in the attached file.
No VBA please only with formula which will help.


Thanks
Raj
 

Attachments

  • CM DATA.xlsx
    56.1 KB · Views: 16
Hi Ali Bhai,

  • Thanks for your kind help. The dashboard is perfectly ok but I need some more clarity like when I select ABC then in master data u can see that only Jack & John had data but Rock and Ruben is "0" so I don't want Rock and Ruben I only want John and Jack's data. Next if you select DEF you will see that Jack, John, Rock, Ruben, Jimmy contains data but Juno does not contains so I don't want Juno. I hope I can clear the same. Please provide with a solution and it will be a great help.
Thanks
Raj
 
You must log in or register to reply here.
Back
Top