Lookup data from similar table

[abibudraustbistdu]

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

[abibudraustbistdu]

Noone can help me?

[Glenn Kennedy]

You might get some help (but not from me - 'cos I know nothing about VBA) if you posted an Excel sheet showing your EXPECTED RESULT instead of (what looks like) an empty table. To do so, click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic