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
<tbody>
</tbody>
Tab 2
<tbody>
</tbody>
Tab 1
Date | 9/1/14 |
Total | Total |
1 | 2 |
<tbody>
</tbody>
Tab 2
Days | Total | Total |
1 | =a3 | =b3 |
2 |
<tbody>
</tbody>