ST, sorry you are having trouble, but I am having some difficulty following what you are seeing. The copy down to the current day from the previous day should be pretty straightforward, but again, make sure you don't include any columns that have array formulae in them. It would be nice to be able just to copy the entire row, but the arrays won't let you do that, so you have to do it in two or three chunks, being careful to skip the array columns.
Kind regards, -CAPT J
"What would you attempt to do if you knew you could not fail?"