Formula Transpose
In Excel2000, I have the following formula in cell b2...
=+'[08 Expenses.xls]Facilities'!$U$101
I would like to copy this across the row so that cell b3 reads
=+'[08 Expenses.xls]Facilities'!$U$102
and b4 =
=+'[08 Expenses.xls]Facilities'!$U$103 and so on.
Is there some formula that I can use to do this so I don't have to
edit each cell?
THanks
|