T
That's Confidential
=T('C:\My Documents\[March.xls]Performance Indicators'!$D$22:$F$33)&T('C:\My
Documents\[April.xls]Performance
Indicators'!$D$22:$F$33)&T('[May.xls]Performance Indicators'!$D$22:$F$33)
I have merged some cells together, however what I want is for the
information taken from these cells to be listed one below the other. At the
moment, the information is just runnning continuously! Is there anything I
can add into my formula so that it will space the information below
eachother. I can not insert the individual formulas into individual rows, as
some of the source cells dont contain info and so I dont want to copy over
blanks!
Documents\[April.xls]Performance
Indicators'!$D$22:$F$33)&T('[May.xls]Performance Indicators'!$D$22:$F$33)
I have merged some cells together, however what I want is for the
information taken from these cells to be listed one below the other. At the
moment, the information is just runnning continuously! Is there anything I
can add into my formula so that it will space the information below
eachother. I can not insert the individual formulas into individual rows, as
some of the source cells dont contain info and so I dont want to copy over
blanks!