| 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 | |||
Linear Mode
