Tracy wrote:
Roger,
Thank you for the information, but maybe I didn't put the question correctly.

I have a function in one worksheet which pulls information from another
worksheet
Worksheet "Call List" E817

In another worksheet I want to put the information from Call List E817 in
that cell and copy to the right that formula while increasing the row number
only from the Call List worksheet.. E817, E818, E819. Everytime I try to
copy or fill to the right column "E" changes and not the row.


Tracy: Please ignore what you THINK the formulas offered will do and try them
and see what they ACTUALLY do. You have successfully communicated what you want.