Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Transposing information from one sheet of a workbook to another
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 |
#2
|
|||
|
|||
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. "mjano25" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy subtotal information to new sheet | Excel Worksheet Functions | |||
Import data file but exlude information I already have in sheet? | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |