| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a formula to transpose numbers, e.g. change 36 to 63 | Excel Discussion (Misc queries) | |||
| formula to transpose | Excel Worksheet Functions | |||
| I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
| Formula Transpose | Excel Discussion (Misc queries) | |||
| Transpose formula | Excel Worksheet Functions | |||
Threaded Mode
