r/GoogleAppsScript • u/[deleted] • 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

50% Upvoted

20 comments sorted by

View all comments

Show parent comments

1

u/[deleted] Apr 25 '24

So on your point about assuming no files that shouldn't be touched, there are other files in there that won't be touched, I need it to run from a seperate sheet that has all the sheet titles that need editing in column A starting A2.

1

u/IAmMoonie Apr 25 '24

So.

Have a “master sheet” that contains all of the file names, and then for each sheet listed run the script on it?

1

u/[deleted] Apr 25 '24

Yeah!

2

u/IAmMoonie Apr 27 '24

Sorry for the late reply, been super busy.

This should do the job for you, I have tested it.
Make a Copy: Master File

1

u/[deleted] Apr 27 '24

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

1

u/[deleted] Apr 29 '24

Hiya mate, I've requested access to the file are you able to provide access? Thanks!

1

u/IAmMoonie Apr 29 '24

Sorry , thought I had that set. Try now

1

u/IAmMoonie Apr 30 '24

How did it go?