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 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
