Hi!
If you have more than one column of data in source file I think it can
be useful to use R1C1 reference style:
=INDIRECT("R"&COLUMN()&"C"&ROW(),0)
Regards,
J.
On 6 Gru, 17:53, roberto mensa <robb....@gmail.com> wrote:
> In B1
> =INDIRECT("A"&COLUMN(A1))
>
> regards
> r
>
> 2010/12/6 0 1 <hhholme...@gmail.com>
>
>
>
>
>
>
>
> > The source document (sample.xls) contains these data:
>
> > A
> > 1
> > 2
> > 3
> > 4
>
> > In my destination workbook, I would like to put a reference in A1 so
> > when I copy the formula into B1, C1, etc., I get this:
>
> > A 1 2 3 etc.
>
> > Instead I get:
>
> > A 0 0 0 etc.
>
> > I've tried every variation of =sample.xls!$A$1 and none of them do it.
> > Is there another way? This is only needed one time but I'm trying to
> > avoid having to manually edit the formula across 20 columns, which is
> > how many the formula needs to be copied into.
>
> > --
>
> > ---------------------------------------------------------------------------
> > -------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
