Referencing

[mole999]

I have a table were I have a couple of static references, and I need to be able to copy paste across the sheet maintaining the same reference points. The Monday (and other days) value is derived from the week ending value (Sunday) in relation to the top percentage per day, what ever I try one or other reference moves every time and I need to do this cleanly for a year to start with

<!-- Please do not remove this header -->

Excel Workbook
	D	E	F	G	H	I	J	K
13	14.31%	14.27%	14.26%	14.31%	14.44%	14.31%	14.09%
14
15							55211
16							41929
17							10482
18							2800
19
20	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon
21	08/04/19	09/04/19	10/04/19	11/04/19	12/04/19	13/04/19	14/04/19	15/04/19
22	7901	7878	7873	7899	7975	7903	7782	7901
FPG