#1
|
|||
|
|||
VBA for the Dashboard
My company asked me to automate the report In this workbook, the raw data is found in Raw Data Tab and Rawdata for payfort calculation Tab The expected result is in KPI Data Tab
I did all the work manually with pivots and formulas. The raw data will change every day. So I was asked to make this report dynamically so that if I change raw data the KPI will also change. Can anybody help me out and get a dynamic result? https://drive.google.com/open?id=0B_...3dDS1RSXy1JZms |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Interactive Dashboard using power pivot | samhomewood | Excel | 0 | 11-25-2016 05:26 PM |
MSP2013 Dashboard Reports | OTPM | Project | 3 | 05-09-2016 04:34 AM |
Dynamic Dashboard on company intranet | LabProARW | Excel Programming | 0 | 12-16-2014 07:46 AM |
Dashboard | neilw | Excel | 0 | 07-06-2014 12:22 PM |
Powerpoint Dashboard | Villanueva | PowerPoint | 0 | 08-26-2013 10:16 PM |