Macro needed to copy groups of data from one spreadsheet to anothe

T

timdavis100

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Sending each spreadsheet via email to a different person 2
Macro to copy certain data from one workbook into another 3
Error Message - Macro to Unlink MS Queries from Workbook 0
Select and copy certain tabs using macro 7
Macro to disable Refresh Data option? 1
Macro to open file and copy information from worksheet 1
VBA - retrieve data on last create named range from previous inserted named range 0

Top