Table manipulation based on header and details tables

[thaykhov]

Hi Guru's I have a table which is extracted from a database using 2 tables.

1 Header and 1 details table.

I want to display the latest date in column E.

As Column A,B,C is the header table and column D,E is the details table.

Can this be done in vba or a pivot?

Thanks in Advanced.

[AB33]

Try the attached.