0
Undo
Votes
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!
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.