Hi all,
I am new here, I have a charter to create a dashboard in excel that automatically updates itself from the datafile. I have about 100 projects, and one tab will have the data and other will have the dashboard, I want to have the dashboard automatically updated with the data, I also want the users to have the capability of selecting the project and then the data changes automatically, also can this be linked to ppt, please let me know if this can be achieved, thanks a lot for all your help