Hi, I have in Cell (B,3) a count indicating number of rows to be inserted below without deleting values in subsequent cells, in cell (B,4) another count, and so on. Cell (C,3) has an Index Formula. I need a script that can automatically insert the number of rows indicated in Cell (B,3) then run the formula in (C,3) then insert a page break, then repeat the same function for the count that was in Cell (B,4) but now is pushed down by the x inserted number of rows. Kindly note that I am illiterate in macro scripts.

Any help would be greatly appreciated.

I don't understand what you mean by "then run the formula in C3". Assuming your sheet is set to Automatic calculation, there's no need to "run" the formula. It will just be evaluated as usual.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Thank you for your reply. I meant by 'run' 'automatically drag the INDEX formula in cell C3 over the inserted rows'.

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History