Saturday, October 22, 2011

yogi_Move Rows In Sheet1 With A Specified Value To Sheet2

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
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