Good friday afternoon!

I am using a Macro that I received a few years back from a member of this
site (Ron De Bruin, I believe)...

It splits data from a workbook into separate workbooks by a specific field.
Ie if I have employee census information in a file and I want to split it by
manager into a new workbook so I can send just that manager their employees
information it works like a charm (thanks ron!)

I'm not good with using/modifying macros...and now have a worksheet that
contains data in rows 1-8 that needs to be copied to each new workbook along
with the split.

Does anyone have any suggestions?

Thanks in advance!