Hi folks, I'm trying to link cells between spreadsheets in the same workbook and am having problems, I'm wondering if there are any excel gurus out there who could quickly tell me what I'm doing wrong.
The information to be referenced always comes from the same column, but from each successive row in the first worksheet. But I need to copy it ACROSS columns on the 2nd spreadsheet. So I want to copy cell B4, B5, B6 into C1, D1, E1, etc. When I try referencing $B4 it treats it as though it's absolute and I get B4, B4, B4 across all columns. Argh!
I suspect the problem is directly related to my stress level. Any suggestions?
The information to be referenced always comes from the same column, but from each successive row in the first worksheet. But I need to copy it ACROSS columns on the 2nd spreadsheet. So I want to copy cell B4, B5, B6 into C1, D1, E1, etc. When I try referencing $B4 it treats it as though it's absolute and I get B4, B4, B4 across all columns. Argh!
I suspect the problem is directly related to my stress level. Any suggestions?