View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
snax500 snax500 is offline
external usenet poster
 
Posts: 49
Default 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