I am trying to "pull" certain information from a Daily Table into a Weekly
Table.

For example, in the two tables below, I am trying to pull the "Open" figure
from the Daily Table into a Weekly Table, based on the criteria that as the
week changes (e.g. from WeekNum 34 to WeekNum 35) the Weekly Table will
automatically pull the Open figure (i.e. 515) into the relevant cell.

Daily Info Weekly Info

WeekNum Date Open WeekNum Date Open
35 29/08/08 558 35 26/08/08 515
35 28/08/08 526.5 34 18/08/08 610
35 27/08/08 524.5 33 11/08/08 603
35 26/08/08 515 32 04/08/08 538.5
34 22/08/08 522
34 21/08/08 540
34 20/08/08 560
34 19/08/08 576
34 18/08/08 610
33 15/08/08 608
33 14/08/08 581
33 13/08/08 602
33 12/08/08 630
33 11/08/08 603
32 08/08/08 598.5
32 07/08/08 607
32 06/08/08 624.5
32 05/08/08 540.5
32 04/08/08 538.5

This really as me stumped!! Any help would be appreciated.

Kind regards, Gavin.