Thread: copy formula using same references
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
macsworks
 
Posts: n/a
Default copy formula using same references

I wish to copy formula and keep the same references

ie
cell F2 has formula =sum(B2:D2)
copy this to cell G6 so that
cell G6 shows =sum(B2:D2)

but when I copy and paste cell G6 shows =sum(C6:E6)


--
macsworks
------------------------------------------------------------------------
macsworks's Profile: http://www.excelforum.com/member.php...o&userid=29235
View this thread: http://www.excelforum.com/showthread...hreadid=489656

Reply With QuoteReply With Quote