Hi,
I'm trying to copy data from sheet2 into sheet1 using the following formula
='sheet2'!$A1
and then dragging the formula all the way to column Z. I want to keep Column A the same but have it automatically fill the series of A1, A2, A3, and so on but it doesn't do that. Instead it'll copy the same exact information and if I remove the "$" sign, it'll change to ='sheet2'!A1, ='sheet2'!B1, ='sheet2'!C1 and so on.
Any idea how I would be able to solve this?
what I want
<tbody>
</tbody>
what's happening
<tbody>
</tbody>
Thanks!
I'm trying to copy data from sheet2 into sheet1 using the following formula
='sheet2'!$A1
and then dragging the formula all the way to column Z. I want to keep Column A the same but have it automatically fill the series of A1, A2, A3, and so on but it doesn't do that. Instead it'll copy the same exact information and if I remove the "$" sign, it'll change to ='sheet2'!A1, ='sheet2'!B1, ='sheet2'!C1 and so on.
Any idea how I would be able to solve this?
what I want
A | B | C | D | E | |||||
='sheet2'!$A1 | ='sheet2'!$A2 | ='sheet2'!$A3 | ='sheet2'!$A4 | ='sheet2'!$A5 | |||||
<tbody>
</tbody>
what's happening
='sheet2'!$A1 | ='sheet2'!$A1 | ='sheet2'!$A1 | ='sheet2'!$A1 | ='sheet2'!$A1 |
<tbody>
</tbody>
Thanks!