Automated formatting and saving multiple files

Glad to be of help.

If this takes care of your problem don't forget to mark your thread "Solved" and if you like to rate my answer / help you can click on the small star left bottom part of my post.

To help you modify this macro I've written a word document trying to explain what this macro does. Don't hesitate to ask for help if you don't understand.

To write a macro like this you must first find a repeating pattern. In your file Mainblade all blocks of data started with a 1 in the B column so I used that. I could perhaps have tried to find "fb_" but in some cases it was "fb_" then two blank rows and then "fb_" again so I decided no to.

If all your data blocks start with a 1 but in another column the you only need to change the column part.

Alf

One other minor thing. Is there a way to 'format' the output names. This is a VERY MINOR thing but it would be nice if the output files were in order. The program I'm reading them in seems them as filename1, filename10, finename11,.... filename19, filename2, filename20.... etc. So if I could have the names start at 10 instead, or start with 01, 02, 03, etc that would be helpful

Again, this is minor, but I might as well ask.

Thanks
Kerry