Move formula down a row depending on date? possible?

[X99MYKE]

Awkward one to explain but i'll try my best!

I have a work excel document I'm trying to optimize.

The document consists of 3 sheets. Sheet 1 is where we enter values of a peice of kit (temperatures, pressures etc which we've obtained beforehand)

Sheets 2 and 3 are just records of this data, ascending rows for each time (its done once per week)

Currently. We print sheet one, take it in the field to write the info down - then come back and type the data into sheets 2 and 3. But the layout is all over the place compared to sheet one, you're constantly clicking between sheets 2 and 3 and looking for the right cells.

What I'm after is being able to print sheet 1, get the data, come back to computer, fill in sheet one in excel, and it automatically enter those values into sheets 2 and 3 which keep the records in date order.

After some searching around I now know how to make the cells on sheets 2 and 3 copy the value, HOWEVER. Only for that row, that day. When it comes to the next week, entering info into Sheet 1 is just going to overwrite the cells on 2 and 3. What I want is it to enter the information the next week - and it complete this in the row below on sheets 2 and 3.

If it helps, the very first cell of Sheet one is the Date. Is it possible to set it so when the date is entered in sheet one, it knows which row to enter the info in 2 and 3?
It almost seems such a simple thing but I'm stumped by it

Ive attached an example of this - the data isnt anything private or sensitive but I've massively reduced it down to just 4 old rows from 2005 for simplicity (the rows actually are down to almost 1000 now in the live document)

thanks in advance!

[tanasedn]

The best way to do what you want is with VBA. Because of a large number of cells that will contain formulas, the workbook will work very very slow and, maybe, crash.
With formula, you need a couple of IF functions (if "date cell" is blank then nothing, else = the cell you fill in sheet1) but, as I say, it will slow down your workbook calculation.

[TMS]

Personally, I’d put a copy of sheet1 on to a tablet or a laptop, get them to complete it in the field and email a copy to you. Then I’d use a VBA macro to extract the data into the next row on sheet2 and sheet3. You could also add a "completed" marker to the source document.