M
mworth01
I have 2 workbooks. In Column A of workbook Source, I have the number
1 through 20 starting in A1. In the second workbook, Summary, I wan
to link to every third row in Source (for simplicity, these will b
located starting in B1 going down). So in the end, Summary will loo
like: B1=1, B2=4, B3=7, etc.
I can do this manually for each cell but want to find a way that if
manually link to a few of the cells and then copy down the formula, th
rest will automatically be completed. When I remove the dollar sign
from the linked cell's address and then copy down, I get a consisten
but very weird result.
If I manually link the first three cells in Summary I have: B1=1, B2=
and B3=7 and the forumlas look like: ='[Source.xls]Sheet1'!B1 after
delete the dollar signs. If I highlight all three of these linke
cells and copy down, I get the following results:
B1=1, B2=4, B3=7, B4=4, B5=7, B6=10, B7=7, B8=10, B9=13, B10=10
B11=13, etc.
There is a pattern but I don't understand why it is doing that. I
there a way to link to these non-adjacent cells quickly or do I have t
do it manually. Thanks
1 through 20 starting in A1. In the second workbook, Summary, I wan
to link to every third row in Source (for simplicity, these will b
located starting in B1 going down). So in the end, Summary will loo
like: B1=1, B2=4, B3=7, etc.
I can do this manually for each cell but want to find a way that if
manually link to a few of the cells and then copy down the formula, th
rest will automatically be completed. When I remove the dollar sign
from the linked cell's address and then copy down, I get a consisten
but very weird result.
If I manually link the first three cells in Summary I have: B1=1, B2=
and B3=7 and the forumlas look like: ='[Source.xls]Sheet1'!B1 after
delete the dollar signs. If I highlight all three of these linke
cells and copy down, I get the following results:
B1=1, B2=4, B3=7, B4=4, B5=7, B6=10, B7=7, B8=10, B9=13, B10=10
B11=13, etc.
There is a pattern but I don't understand why it is doing that. I
there a way to link to these non-adjacent cells quickly or do I have t
do it manually. Thanks