Update. I solved the issue. Thanks everyone!

"timdavis100" wrote:

I have a data sheet that is grouped by department. The department name is in
column A, starting at ("A2"). I need a macro that will loop through the
worksheet and copy/paste each department's information into a new workbook.
The new workbook will need to have the same columns in row 1, and similar
formatting of columns/rows. I would also like to name the workbook the same
as the the department name in ("A2").

I am using Excel 2007. Thanks!