How do I get cell references to change the number (column) not letter (row) when I use the fill handle across rows?
e.g. If I have a cell reference in Sheet 1 that refers to A2 in Sheet 2 and I want to use the fill handle to take values from A3, A4, A5 of Sheet 2 and run them as headings across the columns of Sheet 1 - how do I do this?
If you just drag the fill handle it uses A2, B2, C2, D2
Thanks
Bookmarks