Insert X Number of Rows Below Based on Value of X

[Closed]
Report
Posts
1
Registration date
Saturday October 27, 2012
Status
Member
Last seen
October 27, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

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.


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
there seems to be little complexities in the sheet. Could you post at some public file sharing site a sample book and reexplain the issue