copy the same pattern repeatedly while incrementing down only 1 row

**tiger10012** · 01-25-2013, 09:03 PM

Hello everyone,
I cannot seem to figure this one out for the life of me.

I am trying to copy data via = onto a new spreadsheet. I have the same 5 cell references being repeated down 1 column.

The problem is. I only want to move down my source data 1 row at a time. Because there are 5 cell references my source data is moving 5 rows at a time.

I have posted an example spreadsheet of what I am doing. I want to have the 5-cell combination repeaded 1000 times but am trying to prevent from doing it all by hand.

If anyone can help me I would be extemely greatful.

**FDibbins** · 01-25-2013, 09:31 PM

I looked at your file, and the logic you are using to decide what goes where, escapes me

the references you have on sheet ID seem to completely random? Can you perhaps explain how you arrived at the references that you did?

B2
H2
L2
L2
P2
B3
H3
L3
L3
P3

**tiger10012** · 01-25-2013, 09:41 PM

Certainly,
The cells you reference above are the pattern 2x
B2
H2
L2
L2
P2
is the combination i want to repeat 1,000 times. It is basically 1 piece of a larger picture, which is to use this for an xml table.

Thanks!

**olasa** · 01-26-2013, 08:23 AM

One way is with this formula: =INDIRECT("'original data'!"&B2&A2)
B2: column number, A2: row number
The column formula copies what's 5rows up, and the rows formula 5rows up +1.
//Ola

...or without the helper column (and not bound to row 2) if it's better:
=INDIRECT("'original data'!"&MID("BHLLP",1+MOD(ROW()+(5-ROW($C$2)),5),1)&(1+INT((ROW()+(5-ROW($C$2)))/5)))
$C$2 is the first formula address.

**bebo021999** · 01-26-2013, 12:04 PM

Another way without helper column

Please Login or Register  to view this content.

**tiger10012** · 01-26-2013, 01:36 PM

Thank you very much for the replies everyone! I am goin to close the thread as the solutions worked great!

copy the same pattern repeatedly while incrementing down only 1 row

LinkBack

Thread Tools

Rate This Thread

Display

copy the same pattern repeatedly while incrementing down only 1 row

Re: copy the same pattern repeatedly while incrementing down only 1 row

Re: copy the same pattern repeatedly while incrementing down only 1 row

Re: copy the same pattern repeatedly while incrementing down only 1 row

Re: copy the same pattern repeatedly while incrementing down only 1 row

Re: copy the same pattern repeatedly while incrementing down only 1 row

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions