Transposing information from one sheet of a workbook to another

M

mjano25

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
 
J

JMB

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning off automatic calculation 0
VBA Coding Help for Beginner 0
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
how do I transpose a row of cells to a column between worksheets? 2
Cell values to an array, then array transpose to another workbook 8
Excel spreadsheet - one column into two columns 2
Changing Rows to Columns 0
Keep original cell formatting when using transpose array formula 1

Top