I have to admit that I am totally out of my depth with this one. I'm
working with Excel 2007. I have worksheet (Master Sheet) that
contains a list of data; depending on the input the number of rows can
be 15 or 500. There are a total of 19 columns, but columns A and B
are key. Column A contains dates and Column B is text. What I need
is to automate the following:

From the "Master Sheet", look at Columns A and B. For every unique
combination, copy those rows into a new worksheet that is named
"Column A, Column B". If that new combination worksheet already
exists, then delete the exsting worksheet and insert a new one.

For example, Column A contains a list of dates and Column B is a list
of place names. I need to create a new worksheet that takes from the
"MasterSheet", all rows that are January 20 and Seattle in columns A &
B and rename the new sheet "20 January Seattle" Depending on how many
rows of data, this could create 5 to 50 new worksheets.

I've been successful in copying & renaming one worksheet, but I can't
conditionally copy the data and I can't seem to copy multiple
sheets.

Any and all help is appreciated.