Hi wonder if anyone can advise how I can record data in a summary excel file for weekly stats.

Stats are produced and saved weekly under the same excel file name but with a different date. I then wanted key data to be filtered into the summary excel file.

I noramlly use the below formula in the summary file:-

=('O:\SalesLogistics\Warehouse\Transport\Suppliers League\[All courier consignment data by month and year 2007.xls]Splits for POM 2006'!$T$7)

but if someone saves the the xcel file with the wrong it won't filter into the summary file.

hope this makes sense!!