Hi All,
Im trying to automate a dash board for financial reporting across branches. This is what mu dashboard looks like:
<tbody>
</tbody>
I then have a tab for each branch which looks like this:
<tbody>
</tbody>
Shop 1 would be the name of the tab.
What formula should i use on the dashboard that looks up the branch tab, then looks up the line name eg sales, then sums the monthly data for the year up until l the date on the dashboard?
Thanks in advance.
Im trying to automate a dash board for financial reporting across branches. This is what mu dashboard looks like:
Date | Nov 16 | |||
Shop 1 | Shop 2 | |||
Sales | 54000 | 45000 | ||
Purchases | 12500 | 24000 |
<tbody>
</tbody>
I then have a tab for each branch which looks like this:
Shop 1 | June 16 | Jul 16 | Aug 16 | |
Sales | 12500 | 10000 | 20000 | |
Purchases | 5000 | 2000 | 4500 | |
Wages | 1500 | 2000 | 3000 | |
<tbody>
</tbody>
Shop 1 would be the name of the tab.
What formula should i use on the dashboard that looks up the branch tab, then looks up the line name eg sales, then sums the monthly data for the year up until l the date on the dashboard?
Thanks in advance.