Forum menu
Topic starter
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.
Posted : 25/02/2017 12:08 pm
Select both, then drag down?
Posted : 25/02/2017 12:09 pm
transpose the 2 cells so they're G1 & H1, then drag down ?
(you can akways re-paste and transpose back afterwards)
Posted : 25/02/2017 12:16 pm
Column()
Posted : 25/02/2017 12:17 pm
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.
Posted : 25/02/2017 12:32 pm
Topic starter
Stoner: in numpty langauge please....
Posted : 25/02/2017 1:28 pm