This is just an example of what I want to do but if I have a worksheet
with, say, 10 rows and 3 columns and I want to write out certain rows
to a new spreadsheet, how can I do that in VBA for Excel?  Here are
the specifics:

Row 1 has field headings and should be in every new spreadsheet that
will be created.

Column B in rows 2-10 has the following values in order: (In the
"real" spreadsheet, I don't know how many rows there will be).

red
red
green
green
green
blue
blue
blue
blue
brown

I would like to create four spreadsheets based on the four unique
colors as follows:
Spreadsheet 1 should contain rows 1-3 from the original spreadsheet
and should be named red.xls.  Spreadsheet 2 should contain row 1 and
rows 3-5 from the original spreadsheet and be named green.xls, etc.
Any suggestions would be greatly appreciated.

Thank you,
Sheldon Potolsky