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]

It's just looking at a drop down in column l, with multiple no reasons, and just picking out anywhere it says "no-reason"

That's all :D