I am trying to filter a list based on the input of an operator into three independent cells, with the returned values (stored in sheet 2), copied over to sheet one.
An example worksheet is attached, with false data, as this is sensitive.
Any help would be appreciated - the following code returns values, but only if it matches exactly (wildcards can be used, so this is not essential), and also not onto Sheet 1.
It may also be worth noting that the real data has 83656 rows, and some values are repeated - ideally all need to be returned.
Please Login or Register to view this content.