# Cells dependent on parent cell

#### bulletkid

##### New Member
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?

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### oldbrewer

##### Well-known Member
 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>

Replies
4
Views
249
Replies
0
Views
167
Replies
3
Views
137
Replies
0
Views
200
Replies
0
Views
291

1,191,120
Messages
5,984,762
Members
439,909
Latest member
daigoku

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back