ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   copy cell from one sheet of worksheet to another sheet (https://www.excelbanter.com/excel-discussion-misc-queries/64114-copy-cell-one-sheet-worksheet-another-sheet.html)

Planetjim

copy cell from one sheet of worksheet to another sheet
 
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!

Pete

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



All times are GMT +1. The time now is 11:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com