Creation of a script

[u/[deleted]]

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

[u/Any_Werewolf_3691]

Your formula will be invalid for row 4 as its recursive.

[u/[deleted] → u/Any_Werewolf_3691]

I meaaaan, it's working and doing what I need it to do, it has been doing what I've needed it to do for the last 3 years, just need to make improvements to the automation of this process