Saturday, October 22, 2011

yogi_Move Rows In Sheet1 With A Specified Value To Sheet2

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
jamietranscendgroup asked:
How do I create a function where eg. IF a cell in a worksheet 1 = 100% then the entire row is moved to worksheet 2 in the same workbook
following is one solution to the problem