Hi guys,
I have a use case : There are two excel files, Data has 5 columns and MacroSheet has 4 columns.
I need to compare 5columns of excel with Data of MacroSheet but column3 has a condition if bank name is PPBL then match and write Macro otherwise change bank name to “-” and then match and write macro to the excel1.
I created this case in REFramework. Its working but not getting correct data.
Data.xlsx (10.8 KB) Excel Data Extraction Use Case.docx (15.2 KB) MacroSheet.xlsx (10.1 KB)