View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Skeep
 
Posts: n/a
Default refering to previous sheet


For example if you have a balance sheet file for November and a balance
sheet file for December and you find out what your ytd expense is:

You just open both spreadsheets and them in December you enter a
formula like this:

=A1 "where A1 is Decembers expense" + "and then open the November sheet
and click on the cell with the YTD totals".

Hope I'm on the right track


--
Skeep
------------------------------------------------------------------------
Skeep's Profile: http://www.excelforum.com/member.php...o&userid=30822
View this thread: http://www.excelforum.com/showthread...hreadid=504868