l KAUTION l
Board Regular
- Joined
- Nov 3, 2005
- Messages
- 90
I need to some how link a cell say "B2" to say cell d28.
This is how I linked it
='C:\excel\link\[Detail - week of 1-3-05.xls]Monday'!$D$28
Which works perfectly fine, except I would like to just drag that throught the rest of the A cells and have the week of date to change.
Cell B3 would look like this
='C:\excel\link\[Detail - week of 1-10-05.xls]Monday'!$D$28
Cell B4 would look like this
='C:\excel\link\[Detail - week of 1-17-05.xls]Monday'!$D$28
Is there any way I can make the date change as I drag down the cells?
The A cells contain the correct week of date something like this
1/3/05...........43
1/10/05.........41
1/17/05.........32
So is there a formula or something where I can do this
='C:\excel\link\[Detail - week of =A2.xls]Monday'!$D$28
And the A2 would change to A3, A4, etc...
Is there a way?
This is how I linked it
='C:\excel\link\[Detail - week of 1-3-05.xls]Monday'!$D$28
Which works perfectly fine, except I would like to just drag that throught the rest of the A cells and have the week of date to change.
Cell B3 would look like this
='C:\excel\link\[Detail - week of 1-10-05.xls]Monday'!$D$28
Cell B4 would look like this
='C:\excel\link\[Detail - week of 1-17-05.xls]Monday'!$D$28
Is there any way I can make the date change as I drag down the cells?
The A cells contain the correct week of date something like this
1/3/05...........43
1/10/05.........41
1/17/05.........32
So is there a formula or something where I can do this
='C:\excel\link\[Detail - week of =A2.xls]Monday'!$D$28
And the A2 would change to A3, A4, etc...
Is there a way?