Need to transfer Data from one workbook to another

[uday]

Hi,

I want to transfer only those items which are not present in Dump file. Also in Column I Name should be automatically pick up from Productivity tracker by sheet name.



Kind Regards,
Roy

 

[GraH - Guido]

Hi, do you know if you have Power Query or Get and Transform on your ribbon? It yes, then these kind of actions are really simple and only involves some mouse clicking and no formula or vba code.
It can be an easy alternative. I've attached a sample file.
If requiring VBA, then please wait for another reply.

The first sheet shows the missing rows only
the second sheet has merged those with the original table.

 

[uday]

Thanks for your help Grah. We don't have such power query option.
Sony VBA integration for this task.