Create a list

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

I have 12 monthly spreadsheets for every month of 2004. In each spreadsheet,
I have a range of cells within a column (A1:A20). Now, in some of my monthly
spreadsheets, this column of cells contains information, and in other
months, the cells don't.

Now, what I want to do is copy over the information from only the cells
within the range of A1:A20 which contain information into a new spreadsheet,
so that in effect, a list is created copying all the information. If there
is no information in the cells, then I want them to be ignored.

Any hints?
 
I have had a look at this and played about, and the formula T(A1:A20) seems
to work, however I don't know how to do this formula for multiple cells. So
for example,

=T('[March.xls]Performance
Indicators'!$D$22:$F$33)+T('[April.xls]Performance
Indicators'!$D$22:$F$33)+T('[May.xls]Performance
Indicators'!$D$22:$F$33)+T('[June.xls]Performance Indicators'!$D$22:$F$33)

When I do this, I just get #Value back!

Any ideas?
 
What about copying all the info over into a merged cell, and then formatting
cell so that it lists everything in alphabetical order or something like
that? Then the blanks would be at the bottom.

Any ideas?
 
Think I have got it sorted out:-

=T('[March.xls]Performance
Indicators'!$D$22:$F$33)&T('[April.xls]Performance
Indicators'!$D$22:$F$33)&T('[May.xls]Performance
Indicators'!$D$22:$F$33)&T('[June.xls]Performance Indicators'!$D$22:$F$33)
 
Back
Top