Cells dependent on parent cell

[bulletkid]

Hi,

This is my first post but I am not new here . My apologies; have to skip the pleasantries as I am in urgent need of a solution;

I am trying to make a cell's properties follow a 'parent cell' like the example here:

	Availability			Availability
Date	Item 1	Item 2		Date	Item 1	Item 2
11/28/2016				11/29/2016		1
11/29/2016		1		11/30/2016
11/30/2016				12/1/2016	1
12/1/2016	1			12/2/2016
12/2/2016				12/3/2016
12/3/2016				12/4/2016
12/4/2016				12/5/2016
12/5/2016				12/6/2016

<tbody>
</tbody><colgroup><col><col span="3"><col><col span="2"></colgroup>

- Say I need to reference an item's availability to a specific date; the cells in the 'date' column being dynamic.
- The 'availability' columns are manual input but I need the values in those cells to follow the date on the left column, which moves 'up' each day.

I may need a VBA solution for this as I have tried every trick in my book to get it right.

Can anyone help me?

 

[oldbrewer]

	Availability = stock level
Date	Item 1	Item 2
08/11/2016
09/11/2016		1
10/11/2016
11/11/2016	1	-1						Item 1	Item 2
12/11/2016						date	19/11/2016	3	0
13/11/2016		5
14/11/2016	4
15/11/2016
16/11/2016		-3				this formula gives stock position on any specified day
17/11/2016	-2
18/11/2016		-2				for item 1
19/11/2016						=SUMPRODUCT(($A$3:$A$32<=$H$7)*($B$3:$B$32))
20/11/2016
21/11/2016	4
22/11/2016		4				so substitute =today() for 19/11/16
23/11/2016
24/11/2016						and you have a dynamic daily stock level
25/11/2016
26/11/2016	-3
27/11/2016
28/11/2016		-2
29/11/2016
30/11/2016
01/12/2016
02/12/2016
03/12/2016
04/12/2016
05/12/2016
06/12/2016
07/12/2016

<colgroup><col><col span="6"><col><col span="4"></colgroup><tbody>
</tbody>