I have a worksheet. Each row has a trade details. Need to submit Security and Quantity on other web or mainframes applications. It will displays the trades with the given input. Need to check the fields from excel sheet with the displayed trades and update the status. For Eg: Broker field is not matching with then status is Broker mismatch. If money field is not matching then status is Money mismatch. If no trade is displayed then status is trade mismatch.
The available fields in Excel are Security, Quantity, Amount, Process Date, Broker, Settlement Date and at last Mismatch Reason column, it is to be updated. Like this for all the rows.
Could someone please guide me on how to write code to perform this task?