hi @ all

i have a problem to lookup data from one table to another which only differs in some date-fields:

table 1:

Name 1.1.2015 2.1.2015 3.1.2015 4.1.2015 5.1.2015
Earl 5 6 7 3 0
Peter 3 2 1 0 4
Abraham 2 3 4 2 4

table 2:

Name 2.1.2015 4.1.2015
Earl
Peter
Abrahm

Table 2 has to be filled from table 1 by VBA code
Many thanks in advance for your help.

Fred