Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
Worksheet function in excel only works once | Excel Worksheet Functions | |||
Is there a help on the TABLE worksheet function in Excel? | Excel Worksheet Functions | |||
CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
Excel: Add "dBm" and "dBW" to CONVERT worksheet function Power u. | Excel Worksheet Functions |