Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Build link to an other excell doc
Hi!
I've managed to link fileds to an other excell document. IE. ='C:\[calc2009.xls]Page1'!A1 But now I'm trying to build a link so that it updates with a new year every time you change the year. IE. in B1 I write the year 2010. Now the link in B2 changes to ='C:\[calc2010.xls]Page1'!A1 I've tried with ='C:\[calc&B1&.xls]Page1'!A1 and similiar, but with no success. Is this possible? Thanks for your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Build link to an other excell doc
Check your earlier post.
danielh wrote: Hi! I've managed to link fileds to an other excell document. IE. ='C:\[calc2009.xls]Page1'!A1 But now I'm trying to build a link so that it updates with a new year every time you change the year. IE. in B1 I write the year 2010. Now the link in B2 changes to ='C:\[calc2010.xls]Page1'!A1 I've tried with ='C:\[calc&B1&.xls]Page1'!A1 and similiar, but with no success. Is this possible? Thanks for your help! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Build a link to an other excell document. | Excel Discussion (Misc queries) | |||
how to build DDE link with text from another cell | Excel Worksheet Functions | |||
Using text in cells to build a link to within another file | Excel Discussion (Misc queries) | |||
Use Cell Content to Build Link | Excel Worksheet Functions | |||
How do I link data from two different excell files? | Excel Discussion (Misc queries) |