Hello all

I want to make a very simple macro, but its causing me lots of trouble. Might be that my VBA-skills aren't updated

I have a long list of data in column A in Sheet1. I want to create a macro that copies data from cell B1 in Sheet2 to the first empty cell in column A in Sheet1.

I have no problem creating a macro that copies to the last cell with data, but I want the first EMPTY cell.

Can anyone help?

Thanks in advance

Fred