Now I need to transfer data from another spreadsheet. The title of the current spreadsheet is 01-09-09.xls and I need to get data from spreadsheet 01-08-09.xls (the day before) I already have the formula that gives me the day before in cell C40, so I need a formula that uses the date in cell C40 as the title of the spreadsheet that I am pulling data from. For example i would need data from [C40.xls]C8. I hope this makes sense. Thanks!