lawrence24
New Member
- Joined
- Dec 31, 2013
- Messages
- 21
Hi folks,
I've got three worksheets. Total, A and B. On the first sheet, I enter the total, then there's a table where I enter the split of that total for 'A' and 'B'. So say the total is 457, I would then enter a rough split of 227 and 229 for 'A' and 'B' respectively. On the second worksheet for 'A', I just want the total for 'A' on that date to be filled in automatically with what's on the split table. And the same for the 'B' worksheet.
And this needs to be on a new line following the date.
Main table (I would enter the total number for the day, then I would enter my split values)
<tbody>
</tbody>This is my 'A' table:
<tbody>
</tbody>
This is my 'B' table:
<tbody>
</tbody>
So, as I enter the total number, and then split it manually, I need that split value to be entered on a new line for every day.
Does anyone know how to do this!
I've got three worksheets. Total, A and B. On the first sheet, I enter the total, then there's a table where I enter the split of that total for 'A' and 'B'. So say the total is 457, I would then enter a rough split of 227 and 229 for 'A' and 'B' respectively. On the second worksheet for 'A', I just want the total for 'A' on that date to be filled in automatically with what's on the split table. And the same for the 'B' worksheet.
And this needs to be on a new line following the date.
Main table (I would enter the total number for the day, then I would enter my split values)
Date | Total Number | ||||
05/09/2014 | 457 | Split | |||
06/09/2014 | A | B | |||
07/09/2014 | 227 | 229 | |||
08/09/2014 | |||||
09/09/2014 | |||||
10/09/2014 | |||||
11/09/2014 | |||||
<tbody>
</tbody>
Date | Total for A |
05/09/2014 | 227 |
06/09/2014 | 0 |
07/09/2014 | 0 |
08/09/2014 | 0 |
09/09/2014 | 0 |
10/09/2014 | 0 |
11/09/2014 | 0 |
<tbody>
</tbody>
This is my 'B' table:
Date | Total for B |
05/09/2014 | 229 |
06/09/2014 | 0 |
07/09/2014 | 0 |
08/09/2014 | 0 |
09/09/2014 | 0 |
10/09/2014 | 0 |
11/09/2014 | 0 |
<tbody>
</tbody>
So, as I enter the total number, and then split it manually, I need that split value to be entered on a new line for every day.
Does anyone know how to do this!
Last edited: