Enter data into cells based on single cell data

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. I've attached a file with the barebones tables: one main sheet where I'd enter the total for the day, and the split, and then a second sheet (A), and a third sheet (B), which would need to be filled automatically. totalSplit.xlsx

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!

Unfortunately no. What happens in yours is, I would enter a number into B3, then the split values, and those numbers automatically go into B2 in Sheet "A" and Sheet "B". But then, on the first sheet, the next day I would enter a new number, and new split values, but they go into the same cells in the second and third sheets. I need it to go on a new line.

I think this should work, as long as the previous values don't get erased or anything like that! I'll try again tomorrow and post back! I can't manually change the system time as I'm at work, so gotta wait till tomorrow! THANKS! :D

Okay, here's some more samples - I hope it's clear now what I'm asking!

It works! Thanks soooooo much! :D :D You have saved me from going insane!