View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default copy cell from one sheet of worksheet to another sheet

Imagine your total is in cell D20 of a sheet called "Data" - its
formula will besomething like:

=SUM(D1:D19)

In your "Summary" sheet, you will need the formula:

=Data!D20

Hope this helps.

Pete