Automated Dashboard

[Dlinen]

Hi Guys,

I am trying to make myself a dashboard that is updating itself as much as possible. I have one data sheet with all the source data which is in the following format:

Startdatum			new members	New member %	page views	visits
4.1.16	wk	1	0	0	0	0
11.1.16	wk	2	0	0	0	0
18.1.16	wk	3	0	0	0	0
25.1.16	wk	4	0	0	0	0
1.2.16	wk	5	7	1%	4086	750
8.2.16	wk	6	21	8%	1547	256
15.2.16	wk	7	32	11%	1685	291
22.2.16	wk	8	9	3%	1032	258
29.2.16	wk	9	41	10%	2909	403
...	...	...	...	...	...	...
19.12.16	wk	51
26.12.16	wk	52	...	...	...	...
Totals			Sum	=visits/new members	Sum	Sum

<tbody>
</tbody>

and then I have a dashboard which summarizes all the data, which I would like to have updated automatically so i only have to fill in the new data in the data sheet.

Dashboard:

	New Members
	41 (1)
Sparkline last 12 wks (4)	% change between wk 9&8 (2)
	"vs Wk 8" (text that shows vs WK & the second last week with data (3)

<tbody>
</tbody>

In the dashboard the following things should be calculated:

1. New members: Show Value of Last Cell in column Members
2. Growh rate vs. previous week: ((Value of last cell in Members)-(Value of second last cell))/(Value of second last cell)
3. Description cell: Text "VS Week (second last week, i.e. if the last data was entered in week ="vs wk " & 'Sourcedata total'!$C$39
4. Sparkline with the last 12 weeks of data


I hope i explained it in a way that makes sense. feel free to reach out and ask questions. I do have a sample xlsx doc to share if that would help.

Thanks, Dlinen