1
00:00:00,000 --> 00:00:05,002
(upbeat music)

2
00:00:05,002 --> 00:00:06,000
- [Joe] All right,

3
00:00:06,000 --> 00:00:08,000
it's time for another programming challenge.

4
00:00:08,000 --> 00:00:08,009
For this challenge,

5
00:00:08,009 --> 00:00:11,002
you're going to take the Financial Sample workbook

6
00:00:11,002 --> 00:00:13,002
that we've been using in the chapter

7
00:00:13,002 --> 00:00:14,009
and split the worksheet

8
00:00:14,009 --> 00:00:18,006
that contains all the data into multiple worksheets,

9
00:00:18,006 --> 00:00:22,002
each of which represent the data for a given country,

10
00:00:22,002 --> 00:00:24,009
which is contained in column B.

11
00:00:24,009 --> 00:00:27,003
So I'm going to run my finished code

12
00:00:27,003 --> 00:00:30,005
so you can see what your result should look like

13
00:00:30,005 --> 00:00:31,009
when you're done.

14
00:00:31,009 --> 00:00:37,002
So I'm going to go ahead and run my finished solution.

15
00:00:37,002 --> 00:00:38,005
And when I do that, you can see

16
00:00:38,005 --> 00:00:41,008
that there's a new Financial Sample workbook

17
00:00:41,008 --> 00:00:43,001
that has been created.

18
00:00:43,001 --> 00:00:48,004
So let's go ahead and open that up in Excel.

19
00:00:48,004 --> 00:00:50,001
Okay, so when I open this,

20
00:00:50,001 --> 00:00:54,002
we can see that here is the original worksheet

21
00:00:54,002 --> 00:00:56,006
with all of its original data,

22
00:00:56,006 --> 00:00:59,009
and here is the blank Sheet2, which is untouched,

23
00:00:59,009 --> 00:01:01,003
so that's still there.

24
00:01:01,003 --> 00:01:03,004
And there's also new worksheets

25
00:01:03,004 --> 00:01:06,005
for each of the countries in the dataset.

26
00:01:06,005 --> 00:01:10,000
So here's Canada, Germany, France, Mexico,

27
00:01:10,000 --> 00:01:11,008
and the United States.

28
00:01:11,008 --> 00:01:12,009
And you can see

29
00:01:12,009 --> 00:01:17,002
that that data right here is contained within column B.

30
00:01:17,002 --> 00:01:20,004
So the data for each of those countries has been copied over

31
00:01:20,004 --> 00:01:23,009
to the corresponding worksheet,

32
00:01:23,009 --> 00:01:25,009
and filters have been applied

33
00:01:25,009 --> 00:01:30,001
to the top row in each sheet as well.

34
00:01:30,001 --> 00:01:33,009
So for this challenge, you only have to copy over the data.

35
00:01:33,009 --> 00:01:36,007
Don't worry about preserving the formatting

36
00:01:36,007 --> 00:01:39,001
or preserving the header row, okay?

37
00:01:39,001 --> 00:01:42,000
Just copy the data into a new sheet

38
00:01:42,000 --> 00:01:44,002
that represents that country.

39
00:01:44,002 --> 00:01:46,003
So go ahead, give that a try,

40
00:01:46,003 --> 00:01:49,001
and then I'll be back to explain my solution

41
00:01:49,001 --> 00:01:51,000
in a separate video.