VBA - Copy Spreadsheet 1 data and paste it on another spreadsheet

[vbanewbie68]

Dear Sir or Madam.

Please find my screenshot, which is a test dummy data. Column A and B data are from our website's platform, and F and G columns are for another supplier’s year transaction payments.

On that platform, I download a report weekly to get data and that is one spreadsheet (A and B), and then put it onto another spreadsheet, F and G, a template given by another supplier for payment transactions.

Routinely, I copy data one by one from the downloaded report and paste it onto the correct columns in the template (2nd spreadsheet), send it to the transaction process. This is taking a lot of my time to copy and paste.

Please could you advise me how to run a macro to find the way to convert it automatically, to carry data from one spreadsheet to another spreadsheet, to the correct columns?

Thanks in advance

Best regards

 

[vbanewbie68]

Hello and Happy New Year! Hope you all had a lovely festive break.

Does anyone of you can help me on this please? Your time and help are much appreciated.

Best regards

V