Hi Everyone - I need help in below scenario.
I have attached two excel sheets one is named as “DB Sheet” and another is “onlinereport”.
Sheet “DB Sheet” is static and sheet “online report” is dynamic (changing every time when report is generated).
In both the sheets col EmpID is common and I have to append emailID column from “DB sheet” to “onlinereport” sheet for the EmpID present in “online report” sheet.
How I can achieve this scenario.