Linking Range of Cells in a Row

[friesjh]

I have two spreadsheets in a workbook. One is "Master Sheet", the other is "Short Sheet". Like it implies the master sheet has all the pertinent information . The short sheet has information I need at a glance. As I populate the master sheet I would like it to automatically populate the short sheet. The problem being, I want cells A-L in every fifth row to be linked to the short sheet from the master sheet. I had it setup to link just those columns to the short sheet, but that is way too much information. That included the 4 rows of information I really don't want on my short sheet. I tried setting up the first few rows by hand, then dragging down to continue the formulas to following cells, but Excel did not recognize the pattern of every 5th row. Any suggestions?

[xor]

I am not quite sure if I have understood you correct but take a look at the attached file. Sheet Short1 or Short2 may be what you want.

Please note that I have named Master!A3:L30 d

[Pecoflyer]

Hi
if by every fifth row you mean rows 5,10, 15 etc.. and starting in A1 on your " Short sheet" try =IF('Master Sheet'!A$1,INDEX('Master Sheet'!A$1:A$100,ROW()*5,0),"")
Drag right to col L then down as needed

If the cols have headers a slight adjustment will be needed

You can also use INDIRECT, but I do not recommend it, as it is a volatile function

[friesjh]

Does not self populate the short sheet when I enter data on the master sheet. I entered data in row 33 of the master sheet. It should automatically populate the cells on the short sheet. Like when you link cells. Thanks for trying!

[Pecoflyer]

Please post a sample sheet

[xor]

Not sure if your message 05:54 PM is to me, but if it is I would just say:

Open Name Manager, in the "Refers to" field change =Master!$A$3:$L$30 to so big an area as needed, for example:

=Master!$A$3:$L$1000