Hallo!

I'm new with macros and I need help. From excel sheet I get I would like to extract some data and make a new table.

The sheet looks like several pivot tables one after another. In the 1st row I have "Name1", in the 2nd are headings, next 31 rows are for days, next is Total. In 1st column are labels, in other columns is time as hours.

The WS I get is like this:
(C1) (C2) (C3) (C4) (C5)
(R1) Name1
(R2) Day__Type1__Type2__Type3__Type4
(R3) 1___________8:00
(R4) 2
(R5) 3___________8:00
...
(R33) 31__8:00
(R34) Total 120:00__56:00
(R35) Name2
(R36) Day__Type1__Type2__Type3__Type4
(R37) 1___________8:00
(R38) 2___________8:00
...
(R67) 31__8:00
(R68) Total 136:00__40:00
(R69) Name3
...

I was doing this with copy/paste in new columns. Then filetring and deleting useless rows. But this took a lot of time.

Now I woluld like to make new table with "Name", "Date" and "Time" where hours are Type2. I have about 50 "Names" in a sheet and there will be more every month.

Column "Name" is a problem for me, since I only have "Name" in every 34th row. Columns "Date" =IF(ISNUMBER(Day);DATE(2010;7;Day);"") and "Time" =Type2 * 24 are easy.

New table:
Name Date Time
Name1 1.7.2010 8
Name1 3.7.2010 8
Name2 1.7.2010 8
Name2 2.7.2010 8
...

Many thanks