View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dany dany is offline
external usenet poster
 
Posts: 11
Default how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+

how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+1?

When I copy/paste the cell, the sheet reference doesn't change, I get
"sheet1!+1, when I copy/paste link I get a reference to the right sheet but
loose the "+1", e.g. I get "sheet2!. I need help!!!