Hello Experts! I need help figuring out the best way to manage a large amount of data.
Goal: To have a chart dashboard on my first tab that updates when subsequent tabs are updated with daily data.
I have an Excel 2007 workbook (Email Chart.xlsm) with several worksheet tabs (Email_1, _2, _3) containing data. The worksheets are updated daily. Each worksheet has a different range of data and values (imported from various companies).
I'd like to have a chart dashboard that references the data from the subsequent tabs that charts:
Daily Revenue by Email
Daily Impressions by Email
And if possible,
Week over Week Comparisons
Day over Day Comparisons
What I have so far is an ALL Revenue table and a pivot chart. But I'm not sure if the way I populated the table is the most efficient method, since I guess I'll have to rebuild this every month. Do I have to compile separate tables for each new chart? Or is it possible to pull values directly from the existing tabs?
I am comfortable adding VBA modules if that helps!
May I get an expert's eyes to help me on this? Thanks in advance for any help!!