G
Guest
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
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