Thursday, May 24, 2012

yogi_Extract From Sheet1 Into Sheet2 Rows As Specified In Sheet3

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #556    May 23, 2012

user RoberA said:
delete a lot of rows by marking
the problem is, that i have a big document where is only every second row are used. now i mark every single row, right-click, 'delete row'. is there a possibilty to mark a lot of rows (every second) together to make it faster?
in the following generalized proposed solution to the problem, instead of deleting the rows in Sheet1 I have extracted in Sheet2 rows of Sheet1 as specified in Sheet3