Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
cell reference formula
Posted by Shelly on May 16, 2001 8:25 AM
I am trying to reference other cells in a different, much simpler spreadsheet. The problem is that the row and columns headings are transposed. So, my formula is =b10 in cell c5. In c6, the formula is =c10, NOT b11, as it would be if you copied the formula down. There are thirty columns I need to do this to. How can I copy the formula so the column changes but not the row?
Re: cell reference formula
Posted by Kevin James on May 16, 2001 8:30 AM
Re: cell reference formula
Posted by Anon on May 16, 2001 2:54 PM
Also have a look at 17408.html and the replies.
You can use the TRANSPOSE worksheet function (as discussed in the above thread) or alternatively put the following formula in C5 and drag it down :-
=INDIRECT(CHAR((ROW()+61)) & "10")
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.