Enter data on new row based on single changing cell

[lawrence24]

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)

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>

This is my 'A' table:

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!

 

[lawrence24]

Anyone?

 

[lawrence24]

I'm sorry to have to bump this - last try. No one knows how to do this?