Linking Range of Cells in a Row
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?
|