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

Most Active Users - Yesterday
ashokkarale
Anil_G
Yoichi
yangyq10
postwick
chandreshsinh.jadeja
aravindbalineni123
Parvathy
aya
PRASHANT_GABHANE
More details...

Compare & refer data between 2 sheets

Related Topics