dynamic link

[Smat]

I have got some information range by month in an Excel files. In one another
file I want to put some information from the files (the one range by month).
But it will be really great if I have not to change the formula every month
(this files will be use by people without any idea on how work excel)

Could you help me ?


Thanks a lot

 

[Tom Ogilvy]

design your formula so it works in a dynamic fashion based on the month.

 

[Smat]

I don't know what is "design your formula" and "dynamic fashion" sorry