Hi!
I have 25 SIMILAR excel workbooks. And each workbook consists of 48 SIMILAR worksheets each. I want to insert two different formulas in all these worksheets. E.g. in all these 25*48 worksheets, in cell C2, I want to insert =if(A1=0,"Pass","Fail"). And in cell E2, I want to insert =sum(E10:E20). Could you please give me the codes to run on macro. Thanks.