Macro To Move Row to New Sheet if Cell Value is Found on A Range (A3:A40)

[kimpoy1209]

Hi Everyone!

Can you help me come up with a code that allows to:
1. Check if the cell value is found on a range from another sheet (about 50 values, A2:A51 for example)
2. If the cell value is found, then it's entire row gets cut and pasted to another sheet.

So we have three sheets.
1) Master data - contains the data that will be cut and pasted based on the specific cell that needs to be checked on sheet 2
2) Lookup Table - contains the list of values that need to be checked
3) New Table - The table where the row in master data is transferred.

Thank you in advance!

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...f-value-cell-matches-range-another-sheet.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).