You could try something like this:

=INDIRECT("'[08 Expenses.xls]Facilities'!$U$"&100+COLUMN(A1))

in B2, then copy across.

INDIRECT will only work with open workbooks, so you will need to
ensure that the file "08 Expenses.xls" is open for this to work.

Hope this helps.

Pete

On Jan 8, 5:24*pm, snax500 wrote:
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