View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MrPhysics MrPhysics is offline
external usenet poster
 
Posts: 1
Default copying relative reference across worksheets

I want to set up a financial report with a separate worksheet for each month.
I will have column of receipts & expenses for the month and columns of
receipts & expenses for YTD. The YTD will be computed by adding this months
entry to the total from the previous month. When I copy the formulas they
copy as an absolute reference so always refer to January. I could do this
with Quattro but haven't found how to do it with Excel.