Helle everyone

I have been challenging my mediocre VBA skills for a while now by trying to set up macros to make life at work a bit easier, it’s going pretty well so far as the thing I’ve made works, but the code is rather slow, so I was hoping some of you might have a tip to make it a bit more effective.

Basicly what I need to do is move data from one sheet to another. There is of course a catch! I export the data from our webpage to excel, and get the column names fixed. I need to move these to another sheet, to match the column names here, the column names in this sheet differ from the ones in the exported sheet. The last tricky bit is that the columns shift around in the second sheet, as people add new columns for various purposes, the names however, stay the same.

Therefore I set my code up to match the column names of the two sheets and copy/paste according to that. Here a bit of the code that's giving me problems, in practice i need to match 50-100 columns, not just 2 

Please Login or Register  to view this content.
It is incredibly slow, and I was hoping someone might know a more effective way to do the job?

Thanks in advance!