ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I link cells from a workbook, to talley one one sheet? (https://www.excelbanter.com/excel-worksheet-functions/65985-how-do-i-link-cells-workbook-talley-one-one-sheet.html)

Hammer

How do I link cells from a workbook, to talley one one sheet?
 
I have 12 (Months)worksheets in a workbook. I need the selected cells on each
worksheet to tally on a 13th (Yearly Results) sheet. Been fussing with it
for days now. Cant get it! Help!

Ron de Bruin

How do I link cells from a workbook, to talley one one sheet?
 
Hi Hammer

Try this with code
http://www.rondebruin.nl/summary.htm

If you sheet have names like Sheet1, Sheet2, Sheet3 then you can do it also
manual if you want


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Hammer" wrote in message ...
I have 12 (Months)worksheets in a workbook. I need the selected cells on each
worksheet to tally on a 13th (Yearly Results) sheet. Been fussing with it
for days now. Cant get it! Help!





All times are GMT +1. The time now is 06:39 AM.

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