Hi,

I need to compare the P/L daily. I save the each daily file as PL0102.xls,
PL0102.xls and so on.

Date 01/02/2007 02/02/2007
Difference
(B1)
Income 1000 1200
+200
Formulas ('C:\[PL0102.xls]Sheet1'!$B$2) ('C:\[PL0202.xls]Sheet1'!$B$8)

Expenses 500 800
+300

My method is change the dates manually and use "Replace" to change the file
names in each column. I had tried to save the step of "Replace" by using the
formula below but not successful and it comes up with #REF!.
=('C:\[PL)&(text(B1,"ddmm")&(.xls]Sheet1'!$B$2)

Can anyone help? Thanks

Fanny