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!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Data transfer from another spreadsheet
- Thread starter srcasm83
- Start date
-
- Tags
- transferring data
Similar threads
- Question
- Question
