Apologies, in the example given the number 2 is entered in 3 rows below it
and the number 4 is entered in 5 rows. I changed the numbers to avoid
confusion and only made it more so.

Ian Grega

"Ian Grega" wrote:

Hello, I would really appreciate it if anyone can help with the following, my
$70 book has only confused me further.

I am trying to write a macro that will enter a value from a cell into a
variable number of rows below it in the same column. eg copy the value from
cell A1 into the cells commencing at A5 and on for the number of rows
specified by an integer entered in cell A2, and then do the same for B2 etc

In the following example the Number 2 is entered in 4 rows, the number 3 is
entered in 2 rows

2 4
3 5

2 4
2 4
2 4
4
4

Sincerely appreciate someones help.
Ian Grega