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 11:08 am
Select both, then drag down?
Posted : 25/02/2017 11:09 am
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 11:16 am
Column()
Posted : 25/02/2017 11:17 am
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 11:32 am
Topic starter
Stoner: in numpty langauge please....
Posted : 25/02/2017 12:28 pm