Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel transposing worksheets to rows
Is there a way to transpose a group of cells across multiple worksheets to a
single worksheet? For example: All Sheets 1 thru 9 contain values in cells A1-D1. How can this data be placed on a single sheet from A1-D9? |
#2
|
|||
|
|||
Hi
see: http://www.rondebruin.nl/copy2.htm -- Regards Frank Kabel Frankfurt, Germany OhioMilkMan wrote: Is there a way to transpose a group of cells across multiple worksheets to a single worksheet? For example: All Sheets 1 thru 9 contain values in cells A1-D1. How can this data be placed on a single sheet from A1-D9? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how can you add more rows in excel 2000? | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
How to view tiled Excel worksheets by locking rows for scrolling . | Excel Worksheet Functions |