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