I have been working on a sheet that is updated daily. The macro starts by copying the previous days info to a different sheet, and then bringing in the current days info.

I am trying to copy a "Comments" column across from the previous day. I usually select the cell with the look up formula, copy, select the cell to the left (as that column is always full), Ctrl + Down, then use Activecell.Offset (0, 1), and then Ctrl + Shift + Up, paste to populate all the empty cells in the column.

Only this time, the CTRL + Shift + Up is stopping at the first cell with an entry, and not going up to the top.

Is there a way of telling it to go from the cell selected in the 'Activecell.Offset (0, 1)' line (which can vary greatly), up to cell A2, or A3 no matter what data is entered or not in the cells inbetween?

Thanks.