automating function change

  • Thread starter Thread starter leeners82
  • Start date Start date
L

leeners82

I'm wondering if there is a way to alter a function so that each month
a reference in a function changes. More specifically, in this case
every month the file "International Breakdown 'Month' changes so tha
'month' is that current month. Is there a way to have this chang
automated such as referencing another cell where the month is entered?

Here is the current function:
=IF(D10="","",VLOOKUP(D10,'[International Breakdown Month.xls]Re
ss'!$A$7:$L$29,8,FALSE)
 
Hi
this depends if your file is open or not. If it is open you may use
something like
=IF(D10="","",VLOOKUP(D10,INDIRECT("'[International Breakdown " &
TEXT(TODAY(),"MMMM") & ".xls]Recss'!$A$7:$L$29"),8,FALSE))

BUT if this other file is closed, no way to do this
 
is there a way to allow the user through a prompt or similar to selec
which file will be used in the function
 
Back
Top