IF there is 1 excel file contain Employee ID with name …
I want to add employee ID and replace the Name in different file with reference to above file…
Any Solution…
NO,only blank column…
But it contain only short name…I want to replace with proper name…
so how did you going to match , name to name ?
can you show us the screen shot of excel if you dont mind or dummy data
so… have you tried vlookup ?
It Just Like…
I want Add Employee Id And replace Name …
33 Jayesh Patil 03-02-2019 9.35
44 Ganesh Dever 02-03-2019 8
44 Ganesh Dever 03-03-2019 9
.
.
. Just Like That…
Other File Contain Like …
EmolyeeID NAme
33 Jayesh Patil
44 Ganesh Dever…
@Shubham_Akole You want to replace the Employee ID and Name from another File which has Employee ID and Name right?
yes…
@Shubham_Akole It is similar to the previous Solution i had given you , If you can give me the files , I think i can do it
@Shubham_Akole Check this Workflow :
If it’s the Output You needed, I still think there can be a more unique mappping as Mapping Names are Not good as How I achieved it in this Workflow. Since There was Nothing else to be Mapped
GroupByAndSum.zip (17.9 KB)
Please Notify If this in’t what you expected