![]() |
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! |
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