select specific data from a spreadsheet and copy them in a new spreasheet in the same workbook

[AmandaSS]

Dear All,

I have one file with the following data staritng in A3 - C3

table 1
data and hour	region	figure
15/11/2014 00:00:00	SUD	10
15/11/2014 00:00:00	NORTH	4
same hour as above for another 5 rows	(other regions)	.....
15/11/2014 01:00:00	SUD	9
15/11/2014 01:00:00	NORTH	10
same hour as above for another 5 rows	(other regions)	...

<tbody>
</tbody>

I need to group the data by region and for each hour (from 15/11/2014 00:00:00 to 15/11/2014 23:00:00) in a seprated spreadsheet (sheet 2, starting in A2 - C2) in the same workbook. Each sheet (in total there are 7 regions/sheet) should have the mane of the coresponding region in the same workbook.

date and time	region	figure
15/11/2014 00:00:00	SUD	10
15/11/2014 01:00:00	SUD	9
...

<tbody>
</tbody>

dare and time	region	figure
15/11/2014 00:00:00	NORTH	4
15/11/2014 10:00:00	NORTH	10
.....

<tbody>
</tbody>

Can anybody help?
Thanks,
Amanda

 

[Snakehips]

Amanda,

Is the below representative of your data?

Header in row 3 or data in row 3?
One blank row between dates?

Excel Workbook
	A	B	C
3	data and hour	region	figure
4	15/11/2014 00:00	Reg1	10
5	15/11/2014 00:00	Reg2	4
6	15/11/2014 00:00	Reg3	6
7	15/11/2014 00:00	Reg4	8
8	15/11/2014 00:00	Reg5	3
9	15/11/2014 00:00	Reg6	12
10
11	15/11/2014 01:00	Reg1	9
12	15/11/2014 01:00	Reg2	10
13	15/11/2014 01:00	Reg3	9
14	15/11/2014 01:00	Reg4	24
Source

Does the data end after 15/11/2014 23:00:00 ?