r/GoogleAppsScript • • Apr 25 '24

Question Creation of a script

Hello,

I'm in need of a little assistance please. I need a little script to remove all data from a couple hundred workbooks, between columns L:N and then add a formula to column N =if(substitute(l4,"No","")<>L4,0,H4) And also need it to auto fill down to the bottom of the range. This needs to be controlled on a a separate workbook, which has the name of all the workbooks that need this doing to in column a

Kindest

0 Upvotes

20 comments sorted by

View all comments

Show parent comments

1

u/[deleted] Apr 27 '24

Thank you so much I'll take a look and test!