Save each row in a sheet including header as separate excel file.

**Blondyvl** · 05-25-2022, 05:44 PM

Please would it be possible to help me. I want to save each row in one excel sheet including the header into a seperate excel files using column A as the file name. Many thanks

**Kaper** · 05-26-2022, 10:09 AM

One of the options could be:

Please Login or Register  to view this content.

Note that it takes some time to save each file this way, so if you have many rows one tea mug may be not enough while you wait :-)

Save the attached file, run the macro inside (see above) and all created files shall be created in the same folder.

**Blondyvl** · 05-26-2022, 03:29 PM

This is fantastic, thank you so much. Is it possible to add a line if no data in A2 then end as it errors at the end but works a treat. You have made my day. Thank you.

**Kaper** · 05-30-2022, 04:57 AM

Try such modification:

Please Login or Register  to view this content.

Save each row in a sheet including header as separate excel file.

LinkBack

Thread Tools

Rate This Thread

Display

Save each row in a sheet including header as separate excel file.

Re: Save each row in a sheet including header as separate excel file.

Re: Save each row in a sheet including header as separate excel file.

Re: Save each row in a sheet including header as separate excel file.

Thread Information

Users Browsing this Thread

Similar Threads

Macro to export one tab from excel and save a separate sheet in specific file location

[SOLVED] Save each row as a separate file with the same header

Read all doc files of folder, copy all header levels to excel including header numbering.

[SOLVED] writing excel file to separate tab separated text files with header in each

save a single sheet from a workbook as a separate file?

[SOLVED] How do I copy all of excel file including header

[SOLVED] How do I save each sheet as a separate .xls file by using macro?

Bookmarks

Bookmarks

Posting Permissions