(upbeat music)
- [Joe] All right,
it's time for another programming challenge.
For this challenge,
you're going to take the Financial Sample workbook
that we've been using in the chapter
and split the worksheet
that contains all the data into multiple worksheets,
each of which represent the data for a given country,
which is contained in column B.
So I'm going to run my finished code
so you can see what your result should look like
when you're done.
So I'm going to go ahead and run my finished solution.
And when I do that, you can see
that there's a new Financial Sample workbook
that has been created.
So let's go ahead and open that up in Excel.
Okay, so when I open this,
we can see that here is the original worksheet
with all of its original data,
and here is the blank Sheet2, which is untouched,
so that's still there.
And there's also new worksheets
for each of the countries in the dataset.
So here's Canada, Germany, France, Mexico,
and the United States.
And you can see
that that data right here is contained within column B.
So the data for each of those countries has been copied over
to the corresponding worksheet,
and filters have been applied
to the top row in each sheet as well.
So for this challenge, you only have to copy over the data.
Don't worry about preserving the formatting
or preserving the header row, okay?
Just copy the data into a new sheet
that represents that country.
So go ahead, give that a try,
and then I'll be back to explain my solution
in a separate video.