Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  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.