Formula copy

[deanl33069]

OK i will try to explain this,
in column AA6 to AA320 i have a formula of =(k6) all the way down to k320
i need to copy AA6-AA320 into cells AC6toAQ6 acroos then down to aq50

HELP

 

[Sam_D_Ben]

Something like this.

Excel 2013/2016
	AA	AB	AC	AD	AE	AF	AG
6	6	6	6	7	8	9	10
7	7	7
8	8	8
9	9	9
10	10	10
Sheet4

Cell Formulas
Range	Formula
AB6	=AA6
AC6	=OFFSET($AB6,COLUMN()-29,0)
AD6	=OFFSET($AB6,COLUMN()-29,0)
AE6	=OFFSET($AB6,COLUMN()-29,0)
AF6	=OFFSET($AB6,COLUMN()-29,0)
AG6	=OFFSET($AB6,COLUMN()-29,0)

 

[deanl33069]

my number...lol
My print field is ab1-aq38
i need column aa starting (AA6) to copy into ac6-aq38 if data is present.

 

[deanl33069]

AA ac ad ae af

6 aa6 =aa6 =aa7 =aa8 =aa9
7 aa7
8 aa8
9 aa9




.

 

[Sam_D_Ben]

?

I'm starting to think that maybe you want to copy the entries in a single column, or one dimensional range, into a two dimensional array.
Am I close ?
But, it looks like there are 355 entries in the range aa6-aa360, and 495 entries in the range ac6-aq38, so maybe that's not what you want.

My print field is ab1-aq38
i need column aa starting (AA6) to copy into ac6-aq38 if data is present.

Hello Deanl33069, Gerald asked you something valid, Kindly respond with a valid answer.

 

[Gerald Higgins]

I'm outta here. Good luck !