![]() |
#1
|
|||
|
|||
![]() 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? |
#2
|
|||
|
|||
![]()
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 |
#3
|
||||
|
||||
![]()
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
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
![]()
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!
|
#5
|
||||
|
||||
![]()
Please post a sample sheet
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#6
|
|||
|
|||
![]()
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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Dave T | Excel Programming | 1 | 06-01-2016 08:58 PM |
![]() |
kw01 | Excel | 1 | 06-30-2015 05:02 PM |
![]() |
jhamblin | Excel | 1 | 02-20-2015 07:43 AM |
Copying text range of cells to different cells adds an extra line | jpb103 | Word VBA | 2 | 07-23-2014 12:22 PM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |