I need to paste data from a spreadsheet and have it append onto the bottom of previously added data. At the moment I have a macro which allows me to map the columns from one spreadsheet to the columns in another but the data pastes over already copied data. Any help would be appreciated. I have attached the spreadsheet with the macro and the spreadsheet with the data I want to transfer.
Please let me know if you have any questions.
Thanks in advance.