I am working on an excel file where I need to move an entire row to another sheet IF a cell value is found within a range of values from a different worksheet.
E.G. Sheet 1, column C2 contains the value
Sheet2, Columns A2:A100 contains the table values which need to be checked first.
If Sheet 1, column C2 matches any value in Sheet2, range A2:A100 then the entire sheet1, row(x) should be moved to sheet 3.