hello.

G1 contains: =’Daily Quants’!M6+’Daily Quants’!M8+’Daily Quants’!M9+’Daily Quants’!M11

G2 contains: =’Daily Quants’!N6+’Daily Quants’!N8+’Daily Quants’!N9+’Daily Quants’!N11

How do i auto-fill the rest of column g in same fashion? i.e. G3 refers to column O, G4 column P etc etc.

Thanks.

Select both, then drag down?

transpose the 2 cells so they’re G1 & H1, then drag down ?

(you can akways re-paste and transpose back afterwards)

Column()

as Rob alludes to, you need to use information about the cell your formula is in (The G column cells) to direct the content of your formula.

You can use the ROW() of your G cell to give you a number that can be used to define the COLUMN() of the source of your information.

Stoner: in numpty langauge please….