Script to copy rows from OpenOffice sheet to another
$30-5000 USD
已完成
已发布将近 12 年前
$30-5000 USD
货到付款
I need a method of copying rows from one OpenOffice calc sheet from another.
Please see attached OpenOffice calc file. It contains two sheets, sheet1 and sheet2.
Sheet1 contains over 8000 lines of data. I want a script or function that copies every row from Sheet1 whose Column E cell data is "General government net debt" and appends that entire line to Sheet2.
To Sheet2 I have manually copied the first four of such rows just for an example.
To be clear: I do not want you to manually copy these rows, but I want a way to automate this procedure so I can do it myself (and that I can do it myself in the future with other rows of data).