I have Daily Report get generated and Project Code varies and want to map the relevant employee Name and e-mail address to send that particular information (Sample Output) daily to relevant e-mail address.
Please refer to attached sheet.
thanks for your help in advance.
Demo.xlsx (19.2 KB)
You can use Read Range activity to read the excel sheet and pass below for reading the particular sheet
It will change dynamically according the current date
Declare a variable let’s say it’s a Dt1
Now use Read Range activity and declare a variable let’s say Dt2
Now use Join Datatables activity using Department Code as it’s common for both sheets
Now you can use Filter Datatable and output your required columns
You can use Write Range activity to write back to excel
Hope this will help you