Hi,

1. In A5 enter the formula

=INDIRECT("Data!E"&ROW(A5)/5)

2. Highlight A5:A9 and drag the fill handle down as far as necessary.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Gary" wrote:

I am populating value from another worksheet in form format using following
formula in a cell, let us say in A5 of current worksheet.

=Data!E1

Now I want to have contents of worksheet "Data", cell E2 in cell A10 of
current worksheet.

Like that I want to keep using the incremental values for N number of times.
How can I do that?



=



--
Gary
You Will, You Can