try this idea
=INDIRECT("j"&COLUMN(A1))
=INDIRECT("sourcesheetnamehere!j"&COLUMN(A1))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Leonhardtk" wrote in message
...

If I create the formula in A1:

=Worksheet!I4

I want to drag this to the right to copy the formula to other cells to the
right.

By default, A2 would equal:
=Worksheet!J4

If I procede the I4 with a $, I get the same value all accross:

A2: =Worksheet!$I4
A3: =Worksheet!$I4

How do I get
A2: =Workstheet!I5
A3: =Worksheet!I6

etc.

Thanks.