Hi All,

This is a branch off of an older thread from Johnyboytweed found here.[URL="http://www.excelforum.com/excel-general/845121-how-to-split-worksheet-into-multiple-worksheets-based-on-column-content-new-post.html"]

In the attached workbook, I copied 2 sets of code take from Ron de Bruin. I would like to run the macro but include the first 5 rows above my headers in a6:d:6. When i run the macro without the 5 rows entered above, it works flawlessly! I would just like to add some formatting/titles above the headers for each tab. I would greatly appreciate any assistance!

Just want to let everyone that this is not my code, i took it from the thread above. Thanks again!

Mark

Example.xlsm