Repeating a sequence

**Slothook** · 10-28-2011, 03:52 PM

Apologies if this is straight forward, have been attempting to find a solution but its stumped me for 3 hours, its getting late and I'm working to a tight deadline.

I have a set of data in worksheet which is fairly complex, produced by someone else and its laid out in a fashion that it doesn't assist me.

I've opened a second worksheet on sheet 2 and I've tried pulling the relevant data through.

In short, I would like to bring cells A5, A10, A15, A20 and repeated for several hundred more cells, all increasing by 5, from sheet one to sheet 2

I thought this would be easy, namely on sheet 2 I did in the first four cells

=Sheet1!A5
=Sheet1!A10
=Sheet1!A15
=Sheet1!A20

I then highlighted and dragged expecting the sequence to continue - however the next in sequence, much to my dismay is

=Sheet1!A9
=Sheet1!A14

Instead of the desired

=Sheet1!A25
=Sheet1!A30 and so on for several hundred more entries

Can someone point me in the right direction, sure there is a simple solution but struggling to find it

**daddylonglegs** · 10-28-2011, 03:59 PM

Try this formula in B2 copied down

=INDEX(Sheet1!A:A,ROWS(B$2:B2)*5)

**SteveG** · 10-28-2011, 04:04 PM

Hi,

Insert a header in coluumn A in Sheet1 and where you want it returned enter this formula.

=OFFSET(Sheet1!$A$1,ROW($A$5)*ROW(A1),0)

If you cannot put a header in then:

=OFFSET(Sheet1!$A$1,ROW($A$5)*ROW(A1)-1,0)
HTH
Steve

**Slothook** · 10-28-2011, 04:05 PM

You Sir, are a gentlemen and a genius - when I finally win the european lottery I will shower you with gold and lots of female daddylonglegs.

During the intrim you have my sincere thanks as it was driving me crazy