Getting Cell Entry from Previous Cell

Hi Jason,

Thanks, but it didn’t it let me achieve exactly what I wanted to do.

Having entered the formula in A3 (and editing the last part, eg A2*2) I still had to drag that formula down the column to accommodate the number of cells I wanted filled. Certainly if I dragged too far the formula caused the entries to stop at the correct number.

Is there any way to achieve this automatically, ie once the formula is entered in Cell A3 it goes ahead and fills the required number of cells with no further input from the user?

So what I am after is this:
A1 I enter the number of cells I want filled. eg 6
A2 I enter the starting number. eg 5
A3 Here I put the formula, eg something to double the previous entry. So in my example the entry in A3 becomes 10 and the rest of the entries (A4 to A7) are generated without any further action by me.
A4 20
A5 40
A6 80
A7 160 stopping there, since I now have my 6 entries from 5 to 160.

How can I do this?

Robert