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