Running Totals

[itsgrady]

I have a spreadsheet with days of the week as the header for each column.

What I would like to do is use the last column (7th column) for current information. The seventh column will always be the current date - the other 6 columns will be the previous days.

The next day I would like for all data move over to the left and the oldest day roll off the form. So, the current 7 days will always be on the form.

Is there an easy formula to move everything over each day. I was thinking to use a button with VBA code, unless there is an easier way.

Thanks for the help.

 

[itsgrady]

MrExcelPlayground14.xlsx
	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1
2												Aspirate Inv				Pounds Incinterated
3											Date	Acid	Base	Oxidizer	React	T1 day	t1 night	t2day	t2night
4											Tuesday, December 6, 2022	10	46	96	55	210	20	78	48
5	Aspriate	Sat 12/10/2022	Sun 12/11/2022	Mon 12/12/2022	Tue 12/13/2022	Wed 12/14/2022	Thu 12/15/2022	Fri 12/16/2022			Wednesday, December 7, 2022	11	97	21	69	710	24	68	85
6	Acid	16	80	45	33	44	72	88			Thursday, December 8, 2022	75	67	84	29	500	25	98	49
7	Base	92	30	71	52	93	51	58			Friday, December 9, 2022	72	78	45	42	350	72	53	53
8	Oxidizer	94	62	86	64	33	25	56			Saturday, December 10, 2022	16	92	94	39	800	92	71	97
9	React	39	44	88	35	82	40	18			Sunday, December 11, 2022	80	30	62	44	480	26	13	40
10	Aspirate Tot	241	216	290	184	252	188	220			Monday, December 12, 2022	45	71	86	88	410	41	72	54
11											Tuesday, December 13, 2022	33	52	64	35	740	92	33	90
12	Total	Sat 12/10/2022	Sun 12/11/2022	Mon 12/12/2022	Tue 12/13/2022	Wed 12/14/2022	Thu 12/15/2022	Fri 12/16/2022			Wednesday, December 14, 2022	44	93	33	82	960	93	92	85
13	T1 day	800	480	410	740	960	800	970			Thursday, December 15, 2022	72	51	25	40	800	53	90	66
14	t1 night	92	26	41	92	93	53	81			Friday, December 16, 2022	88	58	56	18	970	81	16	97
15	t2day	71	13	72	33	92	90	16
16	t2night	97	40	54	90	85	66	97
17	Tot	1060	559	577	955	1230	1009	1164
Sheet31

Cell Formulas
Range	Formula
E5:J5,E12:J12	E5	=F5-1
K5,K12	K5	=MAX(Table1[Date])
E6:K9	E6	=TRANSPOSE(XLOOKUP(E5,Table1[[Date]:[Date]],Table1[[Acid]:[React]],"",0))
E10:K10,E17:K17	E10	=SUM(E6#)
E13:K16	E13	=TRANSPOSE(XLOOKUP(E12,Table1[[Date]:[Date]],Table1[[T1 day]:[t2night]],"",0))
N5:N14	N5	=N4+1
Dynamic array formulas.

Thank you so much for all your help! The project looks great! I'm very, very happy with it.