Excel Worksheet Function
I have a workbook with 10 worksheets.
I want to create the 11th sheet as a summary sheet. So on the 11th sheet I would like to have column A, row 1 = column A, row 1 of the first worksheet I would like the column to be fixed, the row to be fixed but the worksheet to change automatically. Is there a way to do this without entering each formula individually? |
Excel Worksheet Function
Assuming the 10 source sheets are named: Sheet1, Sheet2, ... Sheet10
In Sheet11, Put in A1: =INDEX(INDIRECT("'Sheet"&COLUMN()&"'!"&"A"&ROW()), 1,1) Copy A1 across to C1, fill down as far as required Col A returns Sheet1's col A, Col B returns Sheet2's col A, and so on .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Rick" wrote: I have a workbook with 10 worksheets. I want to create the 11th sheet as a summary sheet. So on the 11th sheet I would like to have column A, row 1 = column A, row 1 of the first worksheet I would like the column to be fixed, the row to be fixed but the worksheet to change automatically. Is there a way to do this without entering each formula individually? |
All times are GMT +1. The time now is 11:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com