fill data

[Sarah's Team]

I have two worksheets (wkst 1, wkst 2). They are in different files. I was
wanting to fill down the data in a column on wkst 1. The data is being pulled
from a row in wkst 2.

As it is, if I fill down the column formula in wkst 1, it fills the data in
wkst 2 but from a column as well, and I am wanting it to pull from the row in
wkst 2 rather than the column.

Can anyone help? Is this possible?

 

[Stephen Lloyd]

Perhaps try copying the applicable data in the row, selecting the cell in
wkst 2 where you want the data to begin and then going to Edit>Paste Special
and choose the Transpose checkbox.

In my experience I have not found a way to get a horizontal data lay out to
fill vertically. I either use paste special options or a macro.