Auto fill a formula referencing a column and row of another sheet

[Mobafett]

I have set up a formula that returns the value from a cell in a particular sheet (call it Sheet1) to a master sheet (call it Master). The formula =Sheet1!D$1 is written in cell E3 of "Master". I would like cell E4 Master to have "Sheet2" instead of "Sheet1" and cell E5 Master to have "Sheet3" and so on. Is there a way to use the Auto Fill feature down col E (and other columns). Seems easy, but I am an excel novice so any help would be appreciated.

[XOR LX]

Hi,

In E3 of your Master and copy down:

=INDIRECT("Sheet"&ROWS($1:1)&"!D1")

Regards

[sktneer]

The formula above is equivalent to this formula.......

Please Login or Register  to view this content.