Hi-

How can I link a specific cell (it does not have a formula) from workbook 2 to workbook 1. Every day workbook 2 is saved with a specific date. I want to be able to pull in the linked cell into workbook 1, and have the ability t change the date, so previous days pull into the spreadhseet. Any ideas?

Thanks