Copy values from one sheet to another sheet

[fatfish1969]

I have a workbook with 2 sheets.
Sheet 2 called DAILY has a daily running total.
Sheet 1 called NEW_TOTAL has the last date entered for 11 accounts.
I would like to copy the last date record for each person on the DAILY sheet to the NEW_TOTAL sheet.
The last date from the DAILY sheet is automatically changed on the NEW_TOTAL sheet.
See attached for a sample sheet.

[Glenn Kennedy]

=IFERROR(INDEX(DAILY!E:E,AGGREGATE(15,6,ROW(DAILY!$C$2:$C$1000)/(DAILY!$C$2:$C$1000=$B$1),ROWS(A$2:A2))),"")

copied across/down... and in column C:

=IFERROR(INDEX(DAILY!K:K,AGGREGATE(15,6,ROW(DAILY!$C$2:$C$1000)/(DAILY!$C$2:$C$1000=$B$1),ROWS(C$2:C2))),"")

[fatfish1969]

How do you insert the formula into each cell that already contains data?
When I tried, it replaces the value with 0.
Also, I have about 10,000 records on the daily sheet.
How would you put the formula in each dell?

[Glenn Kennedy]

Have I misunderstood you? Did it work in the sample sheet that I attached?

I deleted your expected results and replaced them with my formulae.

To extend to 10,000 rows change the 1000 to 10,000.

[fatfish1969]

Your example works correctly the way that I wanted it to do.
My problem is when I try to insert the formula, it changes the values in each cell to 0.
My question is how do you put the formula into each cell without the cell value getting changed to 0?