Search and update status in 3rd sheet

[adwaitthefighter]

I have three sheets - PO, SBI, Query

We will use the following fields to identify any matches from the Query tab. We should be able to add a list of data on the Query tab, click the “Run Query” button and automatically check if these entries are in the POD or SBI tabs or not, returning a result in the “Match?” column.
·[FONT=&quot] Date - Because other data is held in this field, we need to search for a string like “ddmmyy” (e.g. 010819 for today).[/FONT]
·[FONT=&quot] Amount[/FONT]
·[FONT=&quot] Sort Code [/FONT]
·[FONT=&quot] Account number


I want to write VBA code to achive this.'


Please help.[/FONT]