Could an expert help me out with my dilemma please.
My file could have anything from 2 to 11 sheets. The first sheet [named Rec] is excluded from the criteria, I am only looking at sheets named from Book 1 to Book 10
For each sheet [named Book ?] I need to insert formulas in Row 9 and for each sheet the formulas in B9, C9 & D9 will be different. Other formulas in Row will be consistent in each sheet.
This all sounds very complicated so I have attached a Dummy file that hopefully will make clear my request.
Thanks in advance.
You need the formula in only B9,C9 and D9 of each of the 'book' sheets ? or it has to go down also b10,C10,D10 etc...
then please give us the formula that goes in B and C and D is it the correct one that you have in the file ?