Hi to everyone,

I have a formula which is a reference to another cell in another worksheet.

EXAMPLE:

in A1 I have +'other_worksheet'!A1

When I copy the formula from A1 in A2 the formula changes to:

+'other_worksheet'!A2

The problem is that i would like it to change to B1. I would like to copythe formula in one direction while the reference changes in another direction.

Is there an easy way to do this ?

Thanks for your help

Paolo

Italy