Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking to external files
I am trying to use and external link that is updated each week based on a
week numbered file as below =VLOOKUP(E3,'G:\Mike\In progress\Sameday Product Analysis\[Sameday Database 2010 Values Week 19.xls]Database'!$E:$BH,$M$3+2,FALSE) Is it possible to use a reference to another cell to change the week number. Ie if i use a formulae as below it will generate the current week number i report on. =WEEKNUM(TODAY())-2 The idea being is there a formatt to allow the 19 in the above formulae to be a refference to a cell and therefore will auto change the link or is this not a function of excel? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking to external files
Use edit replace or a defined name to identify the range
-- Don Guillett Microsoft MVP Excel SalesAid Software "Mike" wrote in message ... I am trying to use and external link that is updated each week based on a week numbered file as below =VLOOKUP(E3,'G:\Mike\In progress\Sameday Product Analysis\[Sameday Database 2010 Values Week 19.xls]Database'!$E:$BH,$M$3+2,FALSE) Is it possible to use a reference to another cell to change the week number. Ie if i use a formulae as below it will generate the current week number i report on. =WEEKNUM(TODAY())-2 The idea being is there a formatt to allow the 19 in the above formulae to be a refference to a cell and therefore will auto change the link or is this not a function of excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking to external tables/Graphs | Excel Discussion (Misc queries) | |||
Multiple Hyperlinks - linking external photos/files help | Excel Discussion (Misc queries) | |||
Linking from external application Crystal | Excel Discussion (Misc queries) | |||
XP linking to external cells bug? | New Users to Excel | |||
Linking formula to external spreadsheet | Excel Discussion (Misc queries) |