Date

[Edgar]

I have the following formula in a cell:

=Sheet2!A4

and i want the next cell in that row to disply:

=Sheet2!B4

How would i do this?

Thanks

 

[Peo Sjoblom]

One way

=OFFSET(Sheet2!$A$4,,ROW(1:1)-1)

 

[Earl Kiosterud]

If the "next" cell is to the right, simply copy the to the right. The cell
reference will adjust relatively. Drag the fill handle to copy, or use
Copy/Paste.

 

[Peo Sjoblom]

Oops! I thought he wanted to copy down!