Excel 2007 : Dragging formulas down

**mkmed** · 06-15-2010, 09:19 AM

Hello,

I am trying to drag down formulas that reference cells on a previous page. The items being drug down need to refer to the 37th (i.e. b37, b74,b111 etc...) but each time I drag down, it will not keep this uniform spacing. Please help!!!

Mark

**Ron Coderre** · 06-15-2010, 09:36 AM

Here's a something to get you heading in the right direction:

Referencing Sheet2 from Sheet1
If your formulas begin on Row_1:

A1: =INDEX(Sheet2!$A:$A,ROW()*37)

If your formulas begin on Row_10:

A10: =INDEX(Sheet2!$A:$A,(ROW()-9)*37)

Copying those formulas down increments the reference by 37 cells.

Does that help?

**mkmed** · 06-15-2010, 09:45 AM

I am not following your help too clearly. I will keep playing with it to see if it solves my issue.

**mkmed** · 06-15-2010, 09:59 AM

That is not working as I need it too. The first entry is correct, but the following entries do not follow the pattern of +37 appropriately. I do appreciate your help!!

Mark

**Ron Coderre** · 06-15-2010, 10:05 AM

If you post the formula you're using and let us know what it's not doing correctly, we'll have a better idea of what you need.

**mkmed** · 06-15-2010, 10:18 AM

Here is the formula I have entered: =INDEX('Bid Sheets'!$I:$I,(ROW()-4)*37)
the formula is in C5 and the reference cell is in I3 of the sheet titled Bid Sheets. Any help is greatly appreciated.

I have tried altering the portion that shows -4 to many different things, but it will not return the value I need for some reason.

Mark