Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in


Moving Entire Column if a Cell Value is Found on a Column From Another Workseet

9 months 3 weeks ago #945 by Kim
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!

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo