how to add formula result x number of rows below a cell based on a variable value

I don't think the title explains very well, but didn't know how else to describe what I am trying to do, hope someone can help.

If there is a value in say a12, I would like to add another value in the same column a variable number of rows below based on a value in say cell d1.

So to be clear, a12 holds "add slide". I would like to automatically insert "add slide" 10 rows below in the same column, 10 being held in cell d1

Any help appreciated

Hi 6StringJazzer,
Thanks for taking the time to help out. Your formula does exactly what I asked, however as you thought the real scenario is much more complicated.
Perhaps it would be better if I uploaded a sample workbook to illustrate what I'm trying to achieve. I hoping you would be kind enough to take a look and help me solve the problem.
I'll post again shortly with the sample workbook.
regards

The “working Schedule” sheet is the one I’m asking for help on.
CB 1, CB 2 etc refers to the Cellbuilders on the Grafting Plan sheet.
The “Grafting Plan” sheet provides the data to the working schedule, anything in RED is a variable that can vary the outcome of the data on the working schedule.
D12 – L12 provide the tasks assigned in the working schedule.
Dates shown from D17 – L300 are the dates assigned to the tasks in the working schedule..

You will see I have formulas that bring the data correctly to the working schedule, but what I need is to be able to take account of any changes in the variables on the grafting plan. I have no clue as to how to go about this, a bit beyond my current understanding.
The aim is to get a daily work schedule for all active cellbuilders based upon the grafting plan.
I’ve attached a sample workbook.
Thanks in anticipation.

This is quite a different problem than your original question, which is why we encourage people to describe their problem, and not what they think the solution is. It will take me a little time to digest what is going on here before I get back to you. Someone else may beat me to it.

In an effort to try and find a way forward I stumbled across this code "Code for the InsertRowsAndFillFormulas Macro (#insrtrow)" on this page : http://dmcritchie.mvps.org/excel/insrtrow.htm#offset

Might this help to achieve my goal, if adapted in some way ?

Or at least stimulate some ideas.

Regards