Using a script to compare and delete columns

I have an Excel spreadsheet which I would like to modify.

Actions I want to have done to the spreadsheet using a script.

If data exists in Column A1 and if the quantity shown in Column S1 is 0, then delete the whole line. If S1 has nothing in it, then do not delete the line, only if it has a 0 in that field.
This has to continue for all rows for the entire spreadsheet.

Then, after it does this, I would like to automatically delete the following columns: B-R, and T-Z.

Please Login or Register  to view this content.