View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KGB003 KGB003 is offline
external usenet poster
 
Posts: 1
Default Using a formula to carry totals from 1 sheet to another

I use the formula ='[RENT-EXCEL 2009.xlsx]APR09'!N2 to carry amounts from one
workbook sheet to another. My problem is I have 83 amounts to carry over and
I have to do each one seperately by changing the "N" line number each time
and then I have to verify my worksheet name for each entry.

Is there an easier way.