View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default Copying a formula "literally"

"ArthurJ" wrote:
.. I have the following relative reference formulas in Col A:
+D1
+D2
+D3


I want exactly the same formulas in Col B:
+D1
+D2
+D3

....
Not a direct answer probably,
but on the face of it, why not just point col B to col A ?
eg: in B1: = A1, with B1 copied down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---