If column 1 has data in each of the, say, first 100 rows, and Iinsert an
adjacent column 2 and ensure that column 2 is empty, then I enter data in the
first cell of column 2, then I try to copy the new cell down all the way down
to the bottom of the row that is the same as the last row of column 1, how
can I take advantage of column 1? I sort of would like to press copy A2 then
move left to column 1, then do End Down, then move back to column 2, then
press Enter. But I always end up down at infinity at the bottom of Excel.

Any clues? Thanks.