View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
J Sedoff[_2_] J Sedoff[_2_] is offline
external usenet poster
 
Posts: 26
Default Contents automatically entered into another cell

You can create a cell reference across different tabs/sheets.

If your sub-total line on the detailed breakdown page is say, cell A7 on
Sheet2, then on your cover page, in the cell where you want the sub-total to
be, type in:
='Sheet2'!A7

Hope this helps, Jim