Transposing information from one sheet of a workbook to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to transpose information (names) from one worksheet to another
within the same workbook. I can do it on the same worksheet by using the =
sign then clicking on the box that i want to transpose. However when I
attempt to do this in another worksheet I get an error that says #value. Any
suggestions
 
select the range you need, click copy, select the first cell on the other
workbook you want the info in, click edit/paste special and check the
transpose box. then ESC to clear the copy mode.
 
Back
Top