Copy groups of similar rows to new spreadsheet (& save)

[ericz_kp_totalcomp]

Here is the business problem:

We have a spreadsheet with a lot of rows, several for each manager, and wish to "chunk it out" to make one spreadsheet for each manager.

Envisioned approach:

1. User will manually define "HEADER" range, that will be copied to every target spreadsheet.
2. User will manually define "DATA" range, which is all of the managers' information, one row per employee.
3. Macro should go through DATA, pick out the rows with [MgrValue1] in column A, and copy those (along with HEADER range), to a brand-new single-worksheet .xls file, which is then saved with as MgrValue1.xls.
4. Continue with [MgrValue2], [MgrValue3], etc.

Thanks in advance for the assistance/pointers.

ALSO: how do you get the "file browser" window, for the user to define a path for these files? I currently have it as a text input box -- workable but inelegant. I know that there must be a built-in object for it.

Thanx
EricZ

[Webtest]

Welcome to the Forum ...

ALSO: how do you get the "file browser" window, for the user to define a path for these files? I currently have it as a text input box -- workable but inelegant. I know that there must be a built-in object for it.

If you want to save these sheets as separate files, do you want to save each Manager's information as a separate workbook, and do you want to save the duplicate sheet in the master workbook?

[ericz_kp_totalcomp]

If you want to save these sheets as separate files, do you want to save each Manager's information as a separate workbook, and do you want to save the duplicate sheet in the master workbook?

Multiple sheets are not a concern. We either want to view one sheet of all the data, or give each individual Manager just their data.

Thanx

Z.

[RobDog888]

Sounds like you want to link the workbooks together to your master one. Links are automatically updated upon opening of the master workbook.

[ericz_kp_totalcomp]

Sounds like you want to link the workbooks together to your master one. Links are automatically updated upon opening of the master workbook.

Let me clarify and add some information:
1. We are starting with one large file. The first thing we need to do is to get them broken down into all of the components, which was the problem I'm trying to solve here.
2. The individual files will eventually be emailed out to the individual managers, who aren't on the same network as the central office. I don't think we want to link them, just paste the data.

Thanx
Z.