Hi All,

I am currently in the process of creating a report based on action codes, time & occurances. I have successfully configured it using VLOOKUP's & COUNTIF's (Overview tab & Data tab).

What I am aiming to achieve is to create a dropdown on the overview page with Week 1,2,3,4,5 etc. Then depending on which week is selected the vlookup will look into "WeekX.xls" and display this data (all .xls documents will be in the same format/layout)

Is this achievable to add to my current formulas?

Thanks in advance for any replies/help