Hi all,
Firstly let me say thank you to everyone on here as the help you have provided in the past has been invaluable.
I have been asked to see if it is possible to display on a Sheet information from 25 other sheets into an easy to see at a glance OverView.
Column layout on the source sheets can't be changed
I know I can use the following
[ ='1'!$C$7:$F$7 ] [ ='1'!$H$7:$I$7] [ ='1'!$M$7:$N$7 ]
[ ='1'!$C$8:$F$8 ] [ ='1'!$H$8:$I$8] [ ='1'!$M$8:$N$8 ]
[ ='1'!$C$9:$F$9 ] [ ='1'!$H$9:$I$9] [ ='1'!$M$9:$N$9 ]
I could also use
[ ='1'!$C$7:$N$7 ]
[ ='1'!$C$8:$N$8 ]
[ ='1'!$C$9:$N$9 ]
and hide the columns not required for an at a glance overview
and drag it down the sheet for the 75 odd line needed and then go and change the '1' to '2' and so on to reference the correct sheet, but I was wondering if there was an easier way as that would be over 200 minor edits with the chance of 1 or 10 getting missed, and therefore displaying incorrect data with Option 1, or 70+ with option 2
I'm thinking there must be a more elegant and less prone to mistakes way to do this.
Any and all advice is much appreciated.
Firstly let me say thank you to everyone on here as the help you have provided in the past has been invaluable.
I have been asked to see if it is possible to display on a Sheet information from 25 other sheets into an easy to see at a glance OverView.
Column layout on the source sheets can't be changed
I know I can use the following
[ ='1'!$C$7:$F$7 ] [ ='1'!$H$7:$I$7] [ ='1'!$M$7:$N$7 ]
[ ='1'!$C$8:$F$8 ] [ ='1'!$H$8:$I$8] [ ='1'!$M$8:$N$8 ]
[ ='1'!$C$9:$F$9 ] [ ='1'!$H$9:$I$9] [ ='1'!$M$9:$N$9 ]
I could also use
[ ='1'!$C$7:$N$7 ]
[ ='1'!$C$8:$N$8 ]
[ ='1'!$C$9:$N$9 ]
and hide the columns not required for an at a glance overview
and drag it down the sheet for the 75 odd line needed and then go and change the '1' to '2' and so on to reference the correct sheet, but I was wondering if there was an easier way as that would be over 200 minor edits with the chance of 1 or 10 getting missed, and therefore displaying incorrect data with Option 1, or 70+ with option 2
I'm thinking there must be a more elegant and less prone to mistakes way to do this.
Any and all advice is much appreciated.