slow macro help Excel 2016/2019

Hello, I am having trouble with a recorded macro that used to work fine under previous versions of Excel, but runs extremely slow on Excel 2016/2019. It will initially work pretty quickly on a new computer, but as the macro is repeated, it will extremely slow down, and it will remain that way regardless if the computer is rebooted or not. Works with no issues under Excel 2010 or previous Excel.

Objective: I have a set of data that needs to be copied over from one spreadsheet with masterdata (call it "SpreadsheetB" below) to another spreadsheet (call it "SpreadsheetA" below) at a certain cell, and then once that set of data in "SpreadsheetB" is done, it moves over to the next column in "SpreadsheetA" so I can repeat the macro again.

1. I have zero clue on VB coding (I can sort of make out what it is doing when it is written out)
2. The macro was created/re-created multiple times using conditional references and record macro
3. Offset needs to remain as is as that's how the location(s) of the provided data and that's where the destination pasting should go to
4. I have searched the internet to add in whatever codes that supposedly make it go faster (screen updating, display status bar, etc.)
5. I understand that the way it is doing it right now with Selections and Activate is not the most efficient way to do it so that's why it's slowing down on new version of Excel, but I don't know how to code it.

The macro that I am having problem is coded as below:

Please Login or Register  to view this content.

Hi kebosabi

You MUST avoid the use of "Activate" and "Select" , unless it is absolutely necesary.
Here I attach the first part of your code modified .

You have 45 procedures of copy/paste,
most of them use an offset of 5 down.... but in a few instances (#9, 16, 31 and 38 ) the offset is 12 down
where I got lost was in the 23th instance... thero you play all around the sheet...
All of this could be easily solved y only one loop to repeat all the instances.
Check, and try to finish the conversion.

Please Login or Register  to view this content.