I frequently have to copy a cell down a column to the last row in the worksheet. Auto filling works fine if the column to the left has data in every cell, but this is often not the case. I need a macro which will allow me to select a column which I know to have data in ever cell and then copy data in the active cell to the last row.