Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to autofill the same cell reference across multiple worksheet.
I want to create a summary page on one worksheet that references vertically
(in a column) the same cell from twelve other worksheets, either in the same or different workbooks. I have several such columns, as well as several summary pages. I have tried to use the autofill function, but it does not appear to change the worksheet reference, only the cell reference. The twelve worksheets represent monthly information. The summary page represents an individual in the company. Select information from the monthly worksheet is tracked for each individual to monitor their performance. I am using Office Excel 2003, part of Office Small Business Edition 2003 . |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to autofill the same cell reference across multiple worksheet.
You would use the INDIRECT function.
=INDIRECT("Sheet" & (ROW()) & "!E3") entered in A1 Returns Sheet1!E3. When copied down, A2 will be Sheet2!E3, etc. Gord Dibben MS Excel MVP On Wed, 27 Feb 2008 13:44:03 -0800, MichiganCPA wrote: I want to create a summary page on one worksheet that references vertically (in a column) the same cell from twelve other worksheets, either in the same or different workbooks. I have several such columns, as well as several summary pages. I have tried to use the autofill function, but it does not appear to change the worksheet reference, only the cell reference. The twelve worksheets represent monthly information. The summary page represents an individual in the company. Select information from the monthly worksheet is tracked for each individual to monitor their performance. I am using Office Excel 2003, part of Office Small Business Edition 2003 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using IF function then Autofill-increments down a reference cell | Excel Worksheet Functions | |||
Autofill based on a cell reference | Excel Worksheet Functions | |||
reference autofill. | Excel Worksheet Functions | |||
Autofill/Reference Confusion | Excel Worksheet Functions | |||
Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions |