No, Duke, it is not as simple as that multiple 416 by 15 and that would be
more like it. It is only 15 on one axis but the other one is extensive.
Unfortunately the designer of the original worksheet knows very little about
doing spreadsheets and the way that he did it was just tortuous to read. To
simplify it though, here is a mock-up of the source document:

Nailbiting Crying Yelling
Stealing
Bowser X X X
0
Randy X X X
0
Stilts X X 0 0
Teddy X 0 X
X

And we want to change it to read:
Bowser Randy Stilts Teddy
Nailbiting X X X X
Crying X X X
0
Yelling X X 0 X
Stealing 0 0 0 X

How do we transfer this info? and I do SO appreciate your help!!!


"Duke Carey" wrote:

You cannot combine a Paste Link action with a Transpose action.
Unfortunately, for only 15 cells the most expedient way is to simply
copy/paste link one cell at a time.

If this is a bigger job, or something that has to be done regularly, post
back. There are ways to deal with it, though not without a little effort to
set it up.

"aleeherself" wrote:

Hello! I am trying to copy 15 cells in a row in one document to 15 cells in
a column in another document. The past link function seems to work until I
check the data and find that the data does not transfer accurately. Does
anyone know what the solution is to this problem? I get the information to
paste vertically along the column by highlighting the cells that I want it to
copy into before I click Paste Link, but still the information is totally
wrong!