Copying multiple header row when splitting from 1 worksheet into multiple files

  • Hi Team, I managed to split my data from 1 worksheet into multiple .xls files based on the "TerritoryCode". In the original worksheet, there are 3 header rows, however only 1 header row is being copied to each of the new files.


    Problem :- 3 header rows not copied in all newly created files. Only 1 header row is being copied.
    Data file :- CP for testing.xlsx (this is the files with original data)
    Output file:- MY-MSEMSBH1.xlsx (sample output after running the below code)


    Below is the code & thank you in advance !


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!