Hi,
I a spreadsheet ("Sales") that tracks a total sales figure and each day is a new column. e.g. the below table.
<tbody>
A
B
C
D
1
03/06/2018
04/06/2018
05/06/2018
2
Sales
50,000
60,000
65,000
3
Costs
10,000
32,000
4,000
...
.....
...
....
...
...
106
Salesperson1...