Hello there. I need help. When I enter a date such as in the example below, I want the cells b2 and c2 in Tab 2 to link to cells in a3 and b3 in Tab 1 (as shown below). And when I change to date i.e. I change it to 9/2/14 I want the data in Tab 1 cells a3 and b3 to populate cells b3 and c3 in Tab 2 and to continue that way down those columns. Any help will be appreciated. Thanks.
Tab 1
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]9/1/14
[/TD]
[/TR]
[TR]
[TD]Total
[/TD]
[TD]Total
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]2
[/TD]
[/TR]
</tbody>[/TABLE]
Tab 2
[TABLE="width: 500"]
<tbody>[TR]
[TD]Days
[/TD]
[TD]Total
[/TD]
[TD]Total
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]=a3
[/TD]
[TD]=b3
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Tab 1
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]9/1/14
[/TD]
[/TR]
[TR]
[TD]Total
[/TD]
[TD]Total
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]2
[/TD]
[/TR]
</tbody>[/TABLE]
Tab 2
[TABLE="width: 500"]
<tbody>[TR]
[TD]Days
[/TD]
[TD]Total
[/TD]
[TD]Total
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]=a3
[/TD]
[TD]=b3
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]