Hi,
I am trying to copy a formula down a sheet so I don't have to type them all separately (over 200).
I am copying data from one sheet to another.
so - cell a2 - formula is =sheet1$b1
cell a3 - formula is =sheet1$b1
cell a4 - formula is =sheet1$c1
cell a5 - formula is =sheet1$c1
And I want to copy all the way down column a
so that cell a6 - formula is =sheet1$d1
cell a7 - formula is = sheet1$d1
and so on.
Thanks in advance for your help.
I am trying to copy a formula down a sheet so I don't have to type them all separately (over 200).
I am copying data from one sheet to another.
so - cell a2 - formula is =sheet1$b1
cell a3 - formula is =sheet1$b1
cell a4 - formula is =sheet1$c1
cell a5 - formula is =sheet1$c1
And I want to copy all the way down column a
so that cell a6 - formula is =sheet1$d1
cell a7 - formula is = sheet1$d1
and so on.
Thanks in advance for your help.