How am i able to populate a sumation for multiple sheets
HI all,
I have multiple sheets with data like that below, my question is, is there a simple way to to sum all the figures in the different sheets into consolidated 1 sheet, with the formating remainin the same, without having to do it cell by cell using the "+" or "=" to link them. Centre JAN FEB MAR APR MAY JUN JUL 0306 1 1 1 1 0 1 1 0307 0 1 0 2 2 2 2 0308 1 1 1 0 1 0 0 Thanks in advance Ray |
Try this, Ray:
http://www.officearticles.com/excel/...rk sheets.htm ************ Anne Troy www.OfficeArticles.com "swiftcode" wrote in message ... HI all, I have multiple sheets with data like that below, my question is, is there a simple way to to sum all the figures in the different sheets into consolidated 1 sheet, with the formating remainin the same, without having to do it cell by cell using the "+" or "=" to link them. Centre JAN FEB MAR APR MAY JUN JUL 0306 1 1 1 1 0 1 1 0307 0 1 0 2 2 2 2 0308 1 1 1 0 1 0 0 Thanks in advance Ray |
Hi Anne,
Thank you very much, this is very helpful. Have a good week. "Anne Troy" wrote: Try this, Ray: http://www.officearticles.com/excel/...rk sheets.htm ************ Anne Troy www.OfficeArticles.com "swiftcode" wrote in message ... HI all, I have multiple sheets with data like that below, my question is, is there a simple way to to sum all the figures in the different sheets into consolidated 1 sheet, with the formating remainin the same, without having to do it cell by cell using the "+" or "=" to link them. Centre JAN FEB MAR APR MAY JUN JUL 0306 1 1 1 1 0 1 1 0307 0 1 0 2 2 2 2 0308 1 1 1 0 1 0 0 Thanks in advance Ray |
All times are GMT +1. The time now is 06:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com