Hi all, I have 2 sheets in one excel file. I want to check & compare string the first column ( A Column ) of 2 sheets… If the string is same, then it will refer and copy value from B column or Sheet1 into the B Column of Sheet2. I have made XAML file as attached but don’t know how to do continuous…

Hello @trunghai , Sorry again for delay, really busy with work. not getting much time to look forum’s query. Now, attached file is working fine as per suggestion, you can see my output in xlsx. Compare&Copy.xlsx (9.3 KB) CompareTwoColumns.xaml (35.0 KB) kindly keep us posted if you stuck …

Compare & refer data between 2 sheets

Help

Pankaj.Patil (Robot Master) March 1, 2019, 8:15am 2

Hello @trunghai,

Kindly refer below links,

Cheers,
Pankaj

Topic		Replies	Views
How to compare equality Help excel	24	2556	December 11, 2018
How to compare columns between two different sheets StudioX studiox , question	3	963	December 1, 2022
Compare between 2 sheets Community datatable , excel , studio , question , community , uipath	6	769	December 1, 2022
How to compare data from a excel sheet with another excel sheet and highlight differences in first excel sheet row Studio excel , studio , question , activities_panel	4	892	December 25, 2021
Compare two different excel sheets and write matching result in both the sheets Studio studio , question , activities_panel	7	1134	April 15, 2021

Most Active Users - Yesterday
ashokkarale
Anil_G
ppr
shyamala_shyamu
Josh_James
m-takeda1
Shahabaz
harshika.10732998
sharazkm32
More details...

Compare & refer data between 2 sheets

Related topics