Hello,

Please can anyone help me with the attached VBA code. It works but somehow it copies only one row of data. I need it to copy all data from columns B:G

code.txt

I would appreciate your help.