copy cell from one sheet of worksheet to another sheet

P

Planetjim

This probably has a simple solution, but I can't find it. I have multiple
sheets I'm working with. I want to take the sum of a column in one sheet and
post the total both at the bottom on that page as well as my main page. Thanx
for any help!
 
P

Pete

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
 
Top