View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dimitry dimitry is offline
external usenet poster
 
Posts: 7
Default copying formulas

I have a worksheet in which I transfer stock from sheet to sheet.To
create a new sheet I simply copy the last one and change date.
My formula is f/example c2 of the current =f2 of the one before. How can
I copy this directly without having to update each time.
Much obliged