look accross as I copy down

[Sir Babydum GBE]

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?

[rory]

You could use:
=B1+(OFFSET(Sheet2!$AA$1,0,ROW()-1)*10)
assuming your formula is in A1.

[Charlize]

Not sure what you want but try this.Dim vtimes As Long
Dim item
vtimes = 1
For Each item In Array("A", "B", "C")
Range("A" & vtimes).Formula = "=B" & vtimes & "+(Sheet2!A" & item & "1*10)"
vtimes = vtimes + 1
Next item

[Bob Phillips]

=B1+(INDEX(Sheet2!$1:$1,ROW()+COLUMN($Z$1))*10)

The column $Z$1 is just an aide memoire in case you move the data, if it is concrete, then you could just use

=B1+(INDEX(Sheet2!$1:$1,ROW()+26)*10)

[Aussiebear]

I have a feeling in my water that this is impossible.

Is my water right?

Run.... you need to go RIGHT NOW