I need help in copying data from column to column
I going to give an example.
Example, Worksheet 1, cell A1= bob, cell A2 = mike, cell A3= jim
I want the macro to goto Worksheet 2 and find the first column where the cells a1 through a3 are empty; the cells below a3 may have data in them

Then I want the macro to copy the contents of Worksheet1, a1:a3 into the empty cells (A1:A3) in the first selected empty column in Worksheet 2

The next time I use the macro, there is different data in worksheet 1, in cells a1:a3. The macro will then copy these new string values into the next empty column in worksheet 2

I appreciate any help someone can offer
Mike