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
|