Copy From one Sheet to the Next empty cell on the next

Hello and thank you in advance for any help you can offer.

I have been trying unsuccessfully to find and modify a macro that will copy a dynamic range of data from column A from cell A1 on sheet1 to sheet 2 in the next cell that is empty in column B.

I will be using this macro several times with different amounts of data some times it may be 100 cells and some times it may be a 1000 and each time it runs I will need it to paste in the next empty cell in column B.

This is what I have so far and it works to a point but it paste my data into cell B10021 and which is not what i need.

Please Login or Register  to view this content.

I hope this all makes sense.

thanks for the help

Maybe:

Please Login or Register  to view this content.

thank you for your help it works perfectally