| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro needed to copy groups of data from one spreadsheet to anothe
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I copy Groups from one spreadsheet to another? | Excel Worksheet Functions | |||
| macro needed to compare value and copy data underneath it to anoth | Excel Discussion (Misc queries) | |||
| how do i copy data from the top cell of a filtered list to anothe. | Excel Worksheet Functions | |||
| How do I easily link a block of cells in one spreadsheet to anothe | Excel Discussion (Misc queries) | |||
| Create Macro to Copy Data from one spreadsheet to another | Excel Discussion (Misc queries) | |||
Threaded Mode
