Eliminate headers in a Macro

  • Hi guys, I have this code that opens multiple files and then extract data from those files and put it in a new sheet, I would like to eliminate the headers in every single file the Macro opens, I just want to keep the headers (laboratory, evaluation date, technical fucnionary etc) in the first row (a1,b1,c1,d1,e1,f1,g1,h1,i1).


    The attachments are some files I need to open

    2019-11-11_MD-09-03-DT.xlsm2020-02-02_MD-09-03-DT.xlsm2019-11-11_MD-09-03-DT.xlsm2020-02-02_MD-09-03-DT.xlsm2019-11-11_MD-09-03-DT.xlsm2020-02-02_MD-09-03-DT.xlsm

    Thank you for you help


  • Some changes...

    If I've been helpful, let me know. If I haven't, let me know that too.