split excel file into multiple files based on column

[obruzzi]

Hi guys,

I am trying to split an excel file with over 100 000 rows into different files based on the values in column A. In this case cases A2-A62 have value "1", cases A63-A89 "2", .., cases A120 569-A120601 "120". Row "1" includes headers for the columns.

I am not very experienced with coding in excel, so please, could someone help and provide a ready-to-use VBA code to split the excel file into 120 different files based on their values in column A. Headers (row 1) should be included.

Thank you very much!

PS. I know that there are some codes in the internet, but didn't get them working.

Best,
Obruzzi

 

[bhos123]

will adding in different 120 Worksheets will work?