Hi all,

I am trying to find a way to compare a range of values across another sheet to find all the rows that match any number in the range of cells, but having a bit of an issue coming across a solution that will work. I prefer a formula but will work with a macro if need be.
For business reasons I can't paste the document in question but I can describe following:

I have a sheet (1) that contains the numbers I am looking for which will be the range of cells to compare with.
Another sheet (2) contain a large amount of data with drivers and consignment numbers (consignment numbers are the common factor here)
Whatever row that contain the matching consignment number I would like to be copied to a final sheet (3)

Hope someone got a solution for me as I have been using google to my fullest to try and find a solution that will work but so far no luck.