Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate a combo Box | Excel Worksheet Functions | |||
Populate 120 cell column with successive months entering only firs | Excel Worksheet Functions | |||
REVISED ?? - populate limited cells w/ set value | Excel Worksheet Functions | |||
getting multiple data to populate another worksheet | Excel Worksheet Functions | |||
How to populate column with formula based on value in cell | Excel Worksheet Functions |