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	2559	December 11, 2018
How to compare columns between two different sheets StudioX studiox , question	3	964	December 1, 2022
Compare Excel/Lookup Data Table without getting same value Activities excel , activities , question	6	1019	September 27, 2020
Compare between 2 sheets Community datatable , excel , studio , question , community , uipath	6	798	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	893	December 25, 2021

Compare & refer data between 2 sheets

Related topics