Hi folks

First post so I'll try and be concise

I have a workbook with 4 sheets: Early, Late, Daily, Monthly (the idea being that a worker will fill in values in the Early and Late sheets and the other sheets get filled automatically)

What I'm trying to do is copy the TOTALS column from the EARLY and LATE sheets to the DAILY sheet.

The totals (values only) from EARLY would be copied into DAILY C3:C25 and LATE into DAILY D3:D25 (if that makes sense)

I'm trying to do this using VBA so it is 'automatic'. I would also like to set this up so that each day the daily sheet is updated into a new column with the date at the top (at the moment i'm using text headings - I am aware of the =today() and =Now() but I don't know enough VBA to use this)

So if today is 4 feb columns are C:D, 5 Feb columns are E:F etc

Is this possible?

Thanks in advance
Cam

TEST.xls