Hi,

I was wondering if anyone can help with the following. I have 3
worksheets.

Sheet 1 contains data like the following:

Name Group
--------- ---------
David 1
Peter 1
Jen 2
Paul 3

Sheet 2 contains data like the following

Group Date 1 Date 2 Date 3 .....
--------- --------- ---------- ---------
1 Yes Yes No
2 No Yes Yes
3 No No Yes

Sheet 3 contains the following headings:

Name Group Date 1 Date 2 Date 3 ......
-------- -------- --------- --------- ----------



I would like to write a bit of code that would populate Sheet 3 with
the persons name and all the dates they have a "Yes" in, according to
the group they are in. i.e. The code looks up Sheet 2 for the dates
corresponding to that persons group and then populates sheet 3 with
all the dates. Is this possible?

Many thanks,

David