I am a complete new user to VBA and Macros.

I am wanting to create a macro for copying a cell and pasting it to a new excel file. The process will continue. The difficulty I am having is when pasting a second, third etc time, it will paste on top of the original and not on new line.

So, every time I copy and it will paste onto a new line.

Thank you