Sir Babydum GBE
11-06-2007, 04:50 AM
Lets say I have the following formula in A1 of sheet 1:
=B1+(Sheet2!AA1*10)
I want to copy the formula down - but as I do, I want the sheet 2 reference to stay on the same row but shift to the next column on the right: so A2 of Sheet 1 should read:
=B2+(Sheet2!AB1*10)
I have a feeling in my water that this is impossible.
Is my water right?
=B1+(Sheet2!AA1*10)
I want to copy the formula down - but as I do, I want the sheet 2 reference to stay on the same row but shift to the next column on the right: so A2 of Sheet 1 should read:
=B2+(Sheet2!AB1*10)
I have a feeling in my water that this is impossible.
Is my water right?