Prev: I created a custom template but the background will not print?
Next: Excel2003 vs 2007 ... :(
From: Joe M. on 22 Apr 2010 12:56
I would like to drag to extend the row reference across columns. See below
example. Can this be done?

Col A B C D
E.....
=sheet2!D1 =sheet2!D2 =sheet2!D3 =sheet2!D4


Thanks,
Joe M.


From: Dave Peterson on 22 Apr 2010 13:32
You could replace it with a different formula:

=index(sheet2!d:d,column())



Joe M. wrote:
>
> I would like to drag to extend the row reference across columns. See below
> example. Can this be done?
>
> Col A B C D
> E.....
> =sheet2!D1 =sheet2!D2 =sheet2!D3 =sheet2!D4
>
> Thanks,
> Joe M.

--

Dave Peterson
 | 
Pages: 1
Prev: I created a custom template but the background will not print?
Next: Excel2003 vs 2007 ... :(