ExcelBanter - Excel transposing worksheets to rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel transposing worksheets to rows (https://www.excelbanter.com/excel-worksheet-functions/7495-excel-transposing-worksheets-rows.html)

OhioMilkMan

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?

Frank Kabel

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?

All times are GMT +1. The time now is 06:48 AM.