How to autofill the same cell reference across multiple worksheet.

M

MichiganCPA

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 .
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference the same cell based on tab name 1
How to Auto Reference Worksheet Tab ID's in Formulas? 9
Linking to other worksheets 3
Cell Reference 4
Relative worksheet reference for multiple worksheets in a workbook 5
Absolute Sheet Reference 3
Reference other worksheet 4
Modifying only the worksheet when draging down a cell reference 20

Top