Tuesday, 31 July 2018
  0 Replies
  2.7K Visits
0
Votes
Undo
Hi ExtendOffice Gurus,

I need your kind helping hands please.

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.

Please help. Thank you thank you thank you!
There are no replies made for this post yet.