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

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

If dragging to the right, the references should be B1=Worksheet!I5 &
C1=Worksheet!I6
In this case you'll need to transpose a vertical source to a horizontal
result.
First select a range of cells on your result sheet beginning in A1 and
extending the exact number of cells to the right as your source range
(Worksheet4!I-) is long. In other words if your source is from I4 to I23
your result range will be A1:T1. Both ranges being 20 cells in length.
With the cells selected enter this formula as an array formula:
=TRANSPOSE(Worksheet!$I$4:$I$23)
To commit the formula as an array formula, press Ctrl-Shift-Enter. If done
correctly you'll see that each formula is enclosed in brackets{}.

Best wishes.
Dave


"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.