merging one columns data to the bottom of another

This Will find the address of the said cell

Sub FirstEmptyCell()
MsgBox Range("A65536").End(xlUp).Offset(1, 0).Address
End Sub

This will paste to the first empty cell

Sub MayBeThis()
    Range("D1").Copy Destination:=Range("A65536").End(xlUp).Offset(1, 0)
End Sub

Originally Posted by excellentexcel

dave just as an add on
what code would you to select all cells with data in
lets say
all cells in column c with any cell that has data in it and cut

Is there a specific row to start?

Sub CutAndPaste()

    Range(Range("C1"), Range("C65536").End(xlUp)).Cut Destination:=Range("A65536").End(xlUp).Offset(1, 0)

End Sub

Originally Posted by excellentexcel

apologies i thought i had already linked the page
i thought i might be able to get round this on my won with a few short cuts and recorded macros but doesnt seem i can

Sorry I don't Use xl'07 yet,
I have looked at the workbook....
It would be easier for others if you made the sample just 100 rows deep and explain on the sample what you are trying to achieve, your workbook does not have any details of what your end result should be.
Attach the workbook to your post, if you do not know how to do that, the forum rules explain it.
You need to make it as easy as possible for others to help you....