Insert X Number of Rows Below Based on Value of X

October 26, 2012 at 23:57:30
Specs: Windows 7

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.

See More: Insert X Number of Rows Below Based on Value of X

Report •

October 27, 2012 at 07:18:41
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.

Report •

October 27, 2012 at 08:32:17
Thank you for your reply. I meant by 'run' 'automatically drag the INDEX formula in cell C3 over the inserted rows'.

Report •

Related Solutions

Ask Question