Hi
I have a worksheet with the below detail (A Identifier, B Date, C Amount, D Narrative)
Identifier Date Amount Narrative
Bank 06/05/2015 -60 BX15050165427514 9344567 DDR
I need to check a second worksheet to confirm if this entry appears on it (it will be in the same format) and if so populate column E on the first worksheet with a Narrative confirming if it has been found.
I need some code that will look at the entry on worksheet 1 and check the entries on worksheet 2. If an entry exists on worksheet 2 with the same identifier, date, amount and narrative it will populate column E on worksheet 1 with a specified narrative. i.e. checked.
Thanks
I have a worksheet with the below detail (A Identifier, B Date, C Amount, D Narrative)
Identifier Date Amount Narrative
Bank 06/05/2015 -60 BX15050165427514 9344567 DDR
I need to check a second worksheet to confirm if this entry appears on it (it will be in the same format) and if so populate column E on the first worksheet with a Narrative confirming if it has been found.
I need some code that will look at the entry on worksheet 1 and check the entries on worksheet 2. If an entry exists on worksheet 2 with the same identifier, date, amount and narrative it will populate column E on worksheet 1 with a specified narrative. i.e. checked.
Thanks