MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
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....