Hi Everyone, I’m facing an issue in Excel task. i’m giving my complete description below.
Process Use Case
Open the Data.xlsx file.
The file contains data for payment mode, bank, and RRN.
Open the Macro Sheet.xlsx file.
This file contains macro names for the Data file.
Develop a Bot to capture the right macro names and update the Data file.
Business Rules/Conditions to Automate the Process
The Bot you develop is expected to do the following:
The Bot needs to open the Data file.
In the Data file, the Bot needs to read payment mode, bank name, and RRN number row by row.
The Bot needs to check for all the given data in the Macro Sheet file.
If payment mode, bank name, and RRN number is a (Match) (Valid) then pick up the macro
name and dump it into the Data file in Column E.
If the bank name is SB, CB, HDF, or CIC then consider bank name in Macro sheet as – (Hyphen)
- You may get multiple matches in the MacroSheet.xlsx file, if multiple matches are found, sum up the instances of matches found and log it in column “Number of Matches” – Very Important!
can anyone help me with the solution