Code cleanup

Hey there all,

I have the following code which I have patched together from this forum, and various other places. The code all works, but it is ugly as can be. I was wondering if someone could take the time to explain to me how to clean it up and make it work faster. I use this along with a lot of code on the sheets to split out data from a huge data sheet into individual sheets that can then be reviewed and approved by the various people who are involved. It generates between 50 to 100 files per run, so as you can imagine by looking at my code, it is very slow. However, it is way faster than the way it used to be done (1 data entry person all day every day.)

Please Login or Register  to view this content.

Do you have an example workbook I can run the code on to compare times with?